Script to generate sheet with control-m table names Post: 302778167

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generate Checksum control

I find a idea to generate a Chcksum code to put in a table the file/table are only string (char and number ) ex: file original: value description univocal 20 char/number univocal AABC01 AAAAABBBB8765367BBBAA ...

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

To Generate control chars[^M, ^C etc]

Hi Experts, Please let me know, how to generate control characters in a file. I want to test my script which will check for any control characters in a file before loading the data into the PRD Database. Thanks in Advance, Sapy.

4. Shell Programming and Scripting

a shell script to generate an excel sheet from a text file..

hi, i have a text file that looks like this! i want to generate an excel sheet out of it, removing all the junk data except the addresses that look like . Arrow Electrical Services Rotating Machinery, Electrical Contracting & Mining Specialists Onsite maintenance, breakdown...

5. Shell Programming and Scripting

Create a control file from Table definition

Hi Team, I need to create a control file with a pre-defined structure for a given table name. The table is in teradata. Ex: Table Name: TBL1 Table structure: create multiset table tbl1, no fallback, no before journal, no after journal, checksum = default, default mergeblockratio...

6. 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 ...

7. Programming

Sql developer how to upload the excel sheet in Oracle table

I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records.

8. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one...

9. UNIX for Beginners Questions & Answers

Not able to generate table in email body

Below is the code snippet and I'm not able to generate the table in email, output email has nothing if ; then echo "File $fName exists." awk -F "," ' BEGIN { print "MIME-Version: 1.0" print "Content-Type: text/html" print "Subject: Out OF Network Fee - Portfolio Level Stats" print...

LEARN ABOUT DEBIAN

sqlline

SQLLINE:(1)							   User Commands						       SQLLINE:(1)

NAME

       sqlline - JDBC command-line utility for issuing SQL

SYNOPSIS

       sqlline [ option... ]

DESCRIPTION

       -u <database url>
	      the JDBC URL to connect to

       -n <username>
	      the username to connect as

       -p <password>
	      the password to connect as

       -d <driver class>
	      the driver class to use

       --color=[true/false]
	      control whether color is used for display

       --showHeader=[true/false]
	      show column names in query results

       --headerInterval=ROWS;
	      the interval between which heades are displayed

       --fastConnect=[true/false]
	      skip building table/column list for tab-completion

       --autoCommit=[true/false]
	      enable/disable automatic transaction commit

       --verbose=[true/false]
	      show verbose error messages and debug info

       --showWarnings=[true/false]
	      display connection warnings

       --force=[true/false]
	      continue running script even after errors

       --maxWidth=MAXWIDTH
	      the maximum width of the terminal

       --maxColumnWidth=MAXCOLWIDTH
	      the maximum width to use when displaying columns

       --silent=[true/false]
	      be more silent

       --autosave=[true/false]
	      automatically save preferences

       --outputformat=[table/vertical/csv/tsv]
	      format mode for result display

       --isolation=LEVEL
	      set the transaction isolation level

       --help display this message

       Usage: java sqlline.SqlLine

       -u <database url>
	      the JDBC URL to connect to

       -n <username>
	      the username to connect as

       -p <password>
	      the password to connect as

       -d <driver class>
	      the driver class to use

       --color=[true/false]
	      control whether color is used for display

       --showHeader=[true/false]
	      show column names in query results

       --headerInterval=ROWS;
	      the interval between which heades are displayed

       --fastConnect=[true/false]
	      skip building table/column list for tab-completion

       --autoCommit=[true/false]
	      enable/disable automatic transaction commit

       --verbose=[true/false]
	      show verbose error messages and debug info

       --showWarnings=[true/false]
	      display connection warnings

       --force=[true/false]
	      continue running script even after errors

       --maxWidth=MAXWIDTH
	      the maximum width of the terminal

       --maxColumnWidth=MAXCOLWIDTH
	      the maximum width to use when displaying columns

       --silent=[true/false]
	      be more silent

       --autosave=[true/false]
	      automatically save preferences

       --outputformat=[table/vertical/csv/tsv]
	      format mode for result display

       --isolation=LEVEL
	      set the transaction isolation level

       --help display this message

       -u <database url>
	      the JDBC URL to connect to

       -n <username>
	      the username to connect as

       -p <password>
	      the password to connect as

       -d <driver class>
	      the driver class to use

       --color=[true/false]
	      control whether color is used for display

       --showHeader=[true/false]
	      show column names in query results

       --headerInterval=ROWS;
	      the interval between which heades are displayed

       --fastConnect=[true/false]
	      skip building table/column list for tab-completion

       --autoCommit=[true/false]
	      enable/disable automatic transaction commit

       --verbose=[true/false]
	      show verbose error messages and debug info

       --showWarnings=[true/false]
	      display connection warnings

       --force=[true/false]
	      continue running script even after errors

       --maxWidth=MAXWIDTH
	      the maximum width of the terminal

       --maxColumnWidth=MAXCOLWIDTH
	      the maximum width to use when displaying columns

       --silent=[true/false]
	      be more silent

       --autosave=[true/false]
	      automatically save preferences

       --outputformat=[table/vertical/csv/tsv]
	      format mode for result display

       --isolation=LEVEL
	      set the transaction isolation level

       --help display this message

sqlline 							    August 2008 						       SQLLINE:(1)