SQL database call into Multidimensional Array using Perl Script Post: 302586800

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

multidimensional array in perl

i'm trying to open a file with three or more columns and an undetermined, but finite number of rows. I want to define an array for each row with each element of the row as a sub array. The columns are separated by tabs or spaces. Here's the file: 12x3.12z34b.342sd3.sds 454.23.23.232 ...

2. Shell Programming and Scripting

Awk multidimensional Array

Hello Experts,, Can anybody give me a brief idea what is following bold letter statement is for!! what is the term called so that I can google for it.. It seems to be an array inside another array.. awk' /TXADDR/ { txaddr=$NF } ##understood /TXDATA/ { txdata]=$NF...

3. Shell Programming and Scripting

AWK multidimensional array

In a single dim. awk array, we can use : <index> in <array name> to determine whether a particualar index exists in the array or not. Is there a way to achieve this in a awk multi dim. array ?

4. Programming

multidimensional array using c++ vector

Hi! I need to make dynamic multidimensional arrays using the vector class. I found in this page How to dynamically create a two dimensional array? - Microsoft: Visual C++ FAQ - Tek-Tips the way to do it in 2D, and now i'm trying to expand it to 3D but i don't understand how is the operator working,...

5. Shell Programming and Scripting

Perl help: Creating a multidimensional array of subdirectories and its contents

I'm currently working with dozens of FASTA files, and I'm tired of having to manually change the filename in my Perl script. I'm trying to write a simple Perl script that'll create a 2-dimensional array containing the name of the folders and its contents. For example, I would like the output...

6. Shell Programming and Scripting

perl-data from file save to multidimensional array

i have a file,like 1 3 4 5 6 7 8 9 i want to save it into an array. and then i want to get every element, because i want to use them to calculate. for example: i want to calculate 1 + 3. but i cannot reach my goal. open (FILE, "<", "number"); my @arr; while (<FILE>){ chomp;...

7. Shell Programming and Scripting

multidimensional array in awk

Hi, I was trying to process a file with the help of awk. I want to first display all the rows that contains 01 and at the end of processing I have to print some portion of all the lines. like below. Output expected:

8. Shell Programming and Scripting

PERL : Bind 2D array to SQL

Hi, I am in the need of doing a bulk insert via : SQL - INSERT INTO <table> (SELECT..) OR PLSQL Block - FORALL i IN 1 .. count INSERT INTO <table>(arrayname(i)) I have a 2D array in my perl code which has the rows to be bulk inserted. Is there a way to bind the 2D array to the SQL...

9. Shell Programming and Scripting

Pass perl array to SQL oracle

Hello, Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg : #!/usr/bin/perl @v_array = (1,2,4,5,6,8); $db_userid = 'ni71/ni711'; $bufTPO = qx{ sqlplus -s << EOF $db_userid set verify off set feedback off set...

10. Shell Programming and Scripting

Multidimensional array

I am learning about bash system variables, such as $ , @ and #. I have this piece of script implementing an array and it is doing its job just fine. This is not the only array I will be using. Just for ease of maintenance and more coding I would like to have the arrays in two dimensional...

LEARN ABOUT REDHAT

variable

variable(n)						       Tcl Built-In Commands						       variable(n)

__________________________________________________________________________________________________________________________________________________

NAME

       variable - create and initialize a namespace variable

SYNOPSIS

       variable ?name value...? name ?value?
_________________________________________________________________

DESCRIPTION

       This  command  is  normally used within a namespace eval command to create one or more variables within a namespace.  Each variable name is
       initialized with value.	The value for the last variable is optional.

       If a variable name does not exist, it is created.  In this case, if value is specified, it is assigned to the newly created  variable.	If
       no  value  is  specified,  the new variable is left undefined.  If the variable already exists, it is set to value if value is specified or
       left unchanged if no value is given.  Normally, name is unqualified (does not include the names of  any	containing  namespaces),  and  the
       variable  is  created in the current namespace.	If name includes any namespace qualifiers, the variable is created in the specified names-
       pace.  If the variable is not defined, it will be visible to the namespace which command, but not to the info exists command.

       If the variable command is executed inside a Tcl procedure, it creates local variables linked to the corresponding namespace variables (and
       therefore  these  variables are listed by info locals.)	In this way the variable command resembles the global command, although the global
       command only links to variables in the global namespace.  If any values are given, they are used to modify the  values  of  the	associated
       namespace variables.  If a namespace variable does not exist, it is created and optionally initialized.

       A name argument cannot reference an element within an array.  Instead, name should reference the entire array, and the initialization value
       should be left off.  After the variable has been declared, elements within the array can be set using ordinary set or array commands.

SEE ALSO

       global(n), namespace(n), upvar(n)

KEYWORDS

       global, namespace, procedure, variable

Tcl									8.0							       variable(n)