Sponsored Content
Top Forums Shell Programming and Scripting Script to generate sheet with control-m table names Post 302778369 by hanson44 on Sunday 10th of March 2013 07:00:34 PM
Old 03-10-2013
That assumes someone here knows about control-m
Given the advanced state of the discussion here, it's possible.
I have no idea about control-m beyond what I read a little just now.

Maybe there is some discussion group about control-m that might be more helpful if nobody here responds?
 

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 ... (0 Replies)
Discussion started by: ZINGARO
0 Replies

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... (2 Replies)
Discussion started by: mwrg
2 Replies

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. (2 Replies)
Discussion started by: saps19
2 Replies

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... (8 Replies)
Discussion started by: vemkiran
8 Replies

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... (7 Replies)
Discussion started by: unankix
7 Replies

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 ... (2 Replies)
Discussion started by: pimmit22043
2 Replies

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. (4 Replies)
Discussion started by: ramkumar15
4 Replies

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... (0 Replies)
Discussion started by: hareshvikram
0 Replies

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... (1 Reply)
Discussion started by: vyomdev
1 Replies
scsnapshot(1M)						  System Administration Commands					    scsnapshot(1M)

NAME
scsnapshot - retrieve configuration data about resource groups, resource types, and resources, and generate a shell script SYNOPSIS
scsnapshot [-s scriptfile] [-o imagefile] scsnapshot [-s scriptfile] oldimage newimage DESCRIPTION
Note - Beginning with the Sun Cluster 3.2 release, Sun Cluster software includes an object-oriented command set. Although Sun Cluster software still supports the original command set, Sun Cluster procedural documentation uses only the object-oriented command set. For more infor- mation about the object-oriented command set, see the Intro(1CL) man page. The scsnapshot tool retrieves information from the Cluster Configuration Repository (CCR) about configuration data that is related to resource groups, resource types, and resources. The scsnapshot tool formats the configuration data as a shell script that can be used for the following purposes: o To replicate configuration data on a cluster that has no configured resource groups, resource types, and resources o To upgrade configuration data on a cluster that has configured resource groups, resource types, and resources The scsnapshot tool retrieves configuration data only from the CCR. Other configuration data is ignored. The scsnapshot tool does not take into account the dynamic state of different resource groups, resource types, and resources. You can use this command only in the global zone. OPTIONS
The following options are supported by the scsnapshot tool. If you use an incorrect command option, the correct way to use the command option is displayed. -s scriptfile Stores the generated script in a file called scriptfile. You can use this option only in the global zone. If this option is not specified, the generated script is written to the standard output. If a file called scriptfile already exists, it is renamed as scriptfile.old, and a new file called scriptfile is created. If a file called scriptfile.old already exists, it is overwritten. -o imagefile Stores the generated image file in a file called imagefile. You can use this option only in the global zone. If this option is not specified, an image file is not generated. If a file called imagefile already exists, it is renamed as imagefile.old, and a new file called imagefile is created. If a file called imagefile.old already exists, it is overwritten. oldimage Specifies an image file that contains the old configuration data. newimage Specifies an image file that contains the new configuration data. EXTENDED DESCRIPTION
The output of the scsnapshot tool is an executable Bourne shell-based script. Before you run the script, you might need to manually change some properties to reflect the features of your host. The script compares the following characteristics of the local cluster to the cluster where the script was generated: o Machine architecture o Version of the Solaris Operating System o Version of the Sun Cluster software If the characteristics are not the same, the script writes an error and ends. A message asks whether you want to rerun the script by using the -f option. The -f option forces the script to run, despite any difference in characteristics. The script generated by the scsnapshot tool verifies that the Sun Cluster resource type exists on the local cluster. If the resource type does not exist on the local cluster, the script writes an error and ends. A message asks whether you want to install the missing resource type before you run the script again. To run a script that is generated by the scsnapshot tool, you need solaris.cluster.resource.modify RBAC authorization. For more informa- tion, see the rbac(5) man page. USAGE
This section describes how you can use the scsnapshot tool. Retrieving Configuration Data for Resource Groups, Resource Types, and Resources scsnapshot [-s scriptfile] [-o imagefile] Used without the -o option, the scsnapshot tool generates a script that creates configuration data for clusters that do not already have configured resource groups, resource types, and resources. See Example 1. Used with the -o option, the scsnapshot tool produces an image file that represents the configuration data. The image file can be used in further invocations of the scsnapshot tool to upgrade configuration data on a cluster. See Example 2. To use the scsnapshot tool to retrieve configuration data, you need solaris.cluster.resource.read role-based access control (RBAC) autho- rization. For more information, see the rbac(5) man page. To track differences between versions of configuration data, store the image files in a source control system such as SCCS. Upgrading Configuration Data for Resource Groups, Resource Types, and Resources scsnapshot [-s scriptfile] oldimage newimage The scsnapshot tool generates a shell script that can be used to upgrade the configuration data that is contained in the oldimage file with the configuration data that is contained in the newimage file. To use the scsnapshot tool to upgrade configuration data, you do not need specific RBAC authorization. EXAMPLES
Example 1 To Generate a Shell Script That Retrieves Configuration Data for Resources Groups, Resource Types, and Resources The script that is generated in this example is called scriptfile.sh. example% scsnapshot -s scriptfile.sh Example 2 To Generate a Shell Script That Retrieves Configuration Data and Stores an Image File The script that is generated in this example is called scriptfile.sh. The configuration data is stored in an image file called imagefile. example% scsnapshot -s scriptfile.sh -o imagefile Example 3 To Generate a Shell Script That Upgrades Configuration Data on One Cluster With Configuration Data From Another Cluster This example creates a script that upgrades the configuration data on cluster1 to match the configuration data on cluster2. The configura- tion data for cluster1 is in a file called imagefile1, and the configuration data for cluster2 is in a file called imagefile2. The name of a shell script is not specified, so the generated script is written to the standard output. example% scsnapshot imagefile1 imagefile2 EXIT STATUS
The following exit status codes are returned: 0 The command completed successfully. nonzero An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWsczu | +-----------------------------+-----------------------------+ |Interface Stability |Evolving | +-----------------------------+-----------------------------+ SEE ALSO
Intro(1CL), attributes(5), clconfiguration(5CL), rbac(5), rg_properties(5), rt_properties(5), r_properties(5) Sun Cluster 3.2 22 Jun 2006 scsnapshot(1M)
All times are GMT -4. The time now is 07:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy