Create a control file from Table definition Post: 302905144

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

create control file in UNIX

UNIX gurus: Following is what I am trying to do: I need to create a control file for another file that I am creating. The information needed in the control file is the date in YYYYMMDD format and then the number of records in the other file right justified and lpadded with spaces of 20. So...

2. UNIX for Dummies Questions & Answers

extract table name from a control file

Hi, I need to extract the table name from an oracle control file which comes as the last word in the third line. Ex: LOAD DATA INFILE '/home/user/files/scott.dat' INTO TABLE SCOTT.EMP_SAL FIELDS TERMINATED BY.......... what i want to to is write the table name SCOTT.EMP_SAL to a...

3. Shell Programming and Scripting

Extra control characters being added when I create a file using cat command

Hi, I am using Cygwin.I created a new file and type into it using cat > newfile. When I open this using vi editor, it contains loads of extra control characters. Whats happening?

4. Shell Programming and Scripting

to create an output file as a table

Hi, I have four input files and would like to create an output file as a table. Please check the example below. File 1. 111111 222222 333333 444444 File 2. 555555 666666 777777 888888 File 3. aaaaa bbbbb ccccc ddddd

5. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname' for example ...

6. UNIX for Dummies Questions & Answers

create table file from different files with index

Hi, I've several files with two collumns, where first collumn can be used as index. filename1 and filename2 how to create a file I should start with cat all files and extract first collumn to create an index?

7. Shell Programming and Scripting

Create a File for Version Control

Hi , I have to create a file with 3 columns A,B,C. I have to read the column A,B values from a text pad. Where as Column a contains approximately 10 values and column B has 1 value which is constant. Column C is a version control column ,initially the value would be 1.

8. Shell Programming and Scripting

Script to create the SQLLDR control file from Oracle table.

I need to create the shell script load the few 100 table using the SQLLDR. Need to generate the control file for each table using oracle table. table has "table names" and "column names" using this need create the control file. example table rows below table_nme column_nme DEPT ...

9. Shell Programming and Scripting

Create a pivot table from CSV file

Gents, Can you please help me to create a pivot table from a csv file. ( I have zip the csv file) Using the file attached, columns 1,28 and 21 i would like to get something like this output JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total...

LEARN ABOUT SUNOS

ptree_add_row_to_table

ptree_create_table(3PICLTREE)				  PICL Plug-In Library Functions			     ptree_create_table(3PICLTREE)

NAME

       ptree_create_table, ptree_add_row_to_table - create a table object

SYNOPSIS

       cc [ flag... ] file... -lpicltree [ library... ]
       #include <picltree.h>

       int ptree_create_table(picl_prophdl_t *tbl_hdl);

       int ptree_add_row_to_table(picl_prophdl_t tbl_hdl, int nprops, picl_prophdl_t *proph);

DESCRIPTION

       The ptree_create_table() function creates a table object and returns the handle of the table in tbl_hdl.

       The  ptree_add_row_to_table() function adds a row of properties to the table specified by tbl_hdl. The handles of the properties of the row
       are specified in the proph array and nprops specifies the number of handles in the array. The number of columns in the table is	determined
       from  the  first  row added to the table. If extra column values are specified in subsequent rows, they are ignored. The row is appended to
       the end of the table.

RETURN VALUES

       Upon successful completion, 0 is returned. On failure, a non-negative integer is returned to indicate an error.

       PICL_STALEHANDLE is returned if the handle is no longer valid. This occurs if the PICL tree was refreshed or reinitialized.

       PICL_INVALIDHANDLE is returned if the specified handle never existed.

ERRORS

       PICL_INVALIDARG	       Invalid argument

       PICL_NOTPROP	       Not a property

       PICL_NOTTABLE	       Not a table

       PICL_INVALIDHANDLE      Invalid handle

       PICL_STALEHANDLE        Stale handle

       PICL_FAILURE	       General system failure

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Evolving			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       attributes(5)

SunOS 5.10							    28 Mar 2000 				     ptree_create_table(3PICLTREE)