03-10-2013
they wil schedule the jobs from control-m tool.. through scheduling tab ...
we upload the scripts from unix server in to the control-m server by defining the tables in the control-m table they we define the path of the scripts... script name... and we pass the paramater in set tab..
in control-m we define a table like abc-hemanth
in that table we refer to the script like for example say one unix script by defining path ...and passing soruce file as parameter...
i want to script such that it should connect to control-m server and it should retrieve the table information like table name...and it should store in excel sheet..
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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 ... (0 Replies)
Discussion started by: ZINGARO
0 Replies
2. UNIX for Dummies Questions & Answers
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... (2 Replies)
Discussion started by: mwrg
2 Replies
3. Shell Programming and Scripting
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. (2 Replies)
Discussion started by: saps19
2 Replies
4. Shell Programming and Scripting
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... (8 Replies)
Discussion started by: vemkiran
8 Replies
5. Shell Programming and Scripting
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... (7 Replies)
Discussion started by: unankix
7 Replies
6. Shell Programming and Scripting
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 ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
7. Programming
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. (4 Replies)
Discussion started by: ramkumar15
4 Replies
8. Shell Programming and Scripting
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... (0 Replies)
Discussion started by: hareshvikram
0 Replies
9. UNIX for Beginners Questions & Answers
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... (1 Reply)
Discussion started by: vyomdev
1 Replies
LEARN ABOUT HPUX
ftpconversions
ftpconversions(4) Kernel Interfaces Manual ftpconversions(4)
NAME
ftpconversions - ftpd conversions database
SYNOPSIS
DESCRIPTION
The conversions known by and their attributes are stored in an ASCII file that is structured as below. Each line in the file provides a
description for a single conversion. Fields are separated by colons (:).
Field Description
1 strip prefix
2 strip postfix
3 addon prefix
4 addon postfix
5 external command
6 types
7 options
8 description
strip postfix and addon postfix can be the file extensions or or or The file extensions the ftp server supports and the action that the ftp
server performs is summarized in the table below. This feature is supported only when using the command.
| |
True Filename | Specified Filename | Action
--------------+--------------------+---------------------------------------
filename.Z | filename | Decompress file before transmitting
filename | filename.Z | Compress filename before transmitting
filename | filename.tar | Tar filename before transmitting
filename | filename.tar.Z | Tar and compress filename
| | before transmitting
external command field is used to specify the path of the program/script to be used to perform the action specified for the different file
extensions as described in the above table.
types field indicates the flags that must be checked before compressing, decompressing, tarring and untarring the file requested by the
command.
options field specifies the options for the program/script specified in the external command field.
description is a short description of each conversion.
NOTE: The HP-UX command does not support any option to do or If the user wants to perform any such action, he/she must then write his/her
own program/script to do it and specify the pathname of the program/script in the external command field in the file. Also a copy of the
programs/scripts used to perform the conversions and the respective libraries used by the programs/scripts must be copied into the home
directory of each of the and user accounts for the and users to be able to perform on-the-fly conversions.
WARNINGS
The conversions mechanism does not currently support the strip prefix and addon prefix fields.
FILES
AUTHOR
was developed by the Washington University, St. Louis, Missouri.
SEE ALSO
ftpd(1M), ftpaccess(4).
ftpconversions(4)