Sponsored Content
Full Discussion: Help needed for a script
Homework and Emergencies Homework & Coursework Questions Help needed for a script Post 303018916 by patitapaban on Tuesday 19th of June 2018 06:04:36 AM
Old 06-19-2018
Help needed for a script

TAG flow Between SDR and DELTA
  1. SDR is the Source table.
  2. Delta is the target table having one staging table and one Main table.
  3. Tags flows between SDR and Delta through ER gateway.
  4. From SDR (SDR.CUSTOMER_PRODUCT and SDR.CUSTOMER_PRODUCT_RELATIONSHIP) the Tags flows to ER (SERVICE_ER_SCHEMA.CUSTOMER_PRODUCT and SERVICE_ER_SCHEMA.CUSTOMER_PRODUCT_RELATIONSHIP)
  5. From ER the Tags flows to Delta staging table (dellcnt.ISP_CUST_PROD_MFG_STG_TBL) and Then from Staging to main table(s_asset).
Issues: -
  1. Tags may not move in between ER to Delta staging table
    And
  2. Delta staging table to Delta main table.
At that time, we need to know exactly where the Tag is present. So, we can treat the Tags as external parameter for the script to take input and find out where the Tag is present.

Last edited by rbatte1; 06-19-2018 at 08:46 AM.. Reason: Formatted number lists with LIST=1 tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script needed

Hi I am looking for the script which can move 1month old data from a TXT file.actully in this file data is appended on daily basis.pleasehalp me out. Thanks in advance (3 Replies)
Discussion started by: vpandey
3 Replies

2. Shell Programming and Scripting

Script help needed

I have a code given below... ERROR=`grep "Job Status" ${LOG_FILE}` ERROR=${ERROR##*\(} ERROR=${ERROR%%\)*} if then echo "The job completed successfully" EXIT_STATUS=0 else echo "The job failed" EXIT_STATUS=1 fi can anybody tell me what is ERROR=${ERROR##*\(}... (1 Reply)
Discussion started by: Sagarddd
1 Replies

3. UNIX and Linux Applications

script needed

hi i am new to linux world please help me,i have two files in diff location i need to compare both and i need to see difference b/w them ex /media/txt (file1) xxxxxx xxxxxx xxxxx xxxxxx xxxxxx /media/rev/ (file2) rev is a folder which contains some files so i need to compare the files in... (3 Replies)
Discussion started by: revenna
3 Replies

4. Shell Programming and Scripting

Script needed!! - Please help

Hi All, I have a text file contains the follwoing info: HOST_CONFIG spbf1n01 3181 patrolpv "B6abbKEW5L1TCE5B282445" I E W A HOST_CONFIG spbf1n02 3181 patrolpv "B6abbKEW5L1TCE5B282445" I E W A HOST_CONFIG spbf1n03 3181 patrolpv "B6abbKEW5L1TCE5B282445" I E W A Whenever the String... (6 Replies)
Discussion started by: ntgobinath
6 Replies

5. Shell Programming and Scripting

help needed for a script!!

Hi!! Im new to shell scripting. I have an important assignment to complete in my company tomorrow. Please help me. I have to write an interactive script which does the following thing: There is a file named ""rules"in a folder say /home/f1/ . This file contains text in the form: 123 345... (5 Replies)
Discussion started by: rahul195
5 Replies

6. Shell Programming and Scripting

Help Needed in Sh script

hi, Im trying to select from a sql using shell script and once i get count i need to add the count to the subject line and send mail to every1.. ex : Select count(*) from emp; In Shell script echo $PASSWORD|$ORACLE_HOME/bin/sqlplus $USERID@$DBNAME @$SCRIPT_DIR/emp_count.sql... (1 Reply)
Discussion started by: jkumsi
1 Replies

7. Shell Programming and Scripting

Expect script help needed- script failing if router unavailable

Hey all. Sometimes I'm tasked to change some router configs for the entire network (over 3,000 Cisco routers). Most of the time its a global config parameter so its done with a loop and an IP list as its the same configuration change for all routers. This is working OK. However, sometimes an... (3 Replies)
Discussion started by: mrkz1974
3 Replies

8. UNIX for Dummies Questions & Answers

help in script needed

Hi, I am developing a script for writing out the failed jobs in file, 1)First step i need to create an empty file Status with today's date. 2)After that i need to execute the below command: dsjob -server servername -user uname -password pwd -ljobs projectname This will listout all... (5 Replies)
Discussion started by: pandeesh
5 Replies

9. Shell Programming and Scripting

Help needed for script

Hi, I have a big list like this --> 3285 3289 328D 3291 3295 3299 329D 32A1 I need to make it like --> 3285|3289|328D|3291|3295|3299|329D|32A1 Please suggest. This is Linux OS. (8 Replies)
Discussion started by: solaris_1977
8 Replies

10. Shell Programming and Scripting

Help Needed on Script

Hi team, I am looking to execute some command through xargs. $cat testfile | grep myloc alias myloc='cd /export/nfs-1sv-23/' I am trying to execute that alias as soon as i cat and grep ? I tried with $cat testfile | grep myloc | xargs --> no luck ... Can some one assist me with... (6 Replies)
Discussion started by: itsme488
6 Replies
ici::doc::pod3::sdrtable(3)				       ICI library functions				       ici::doc::pod3::sdrtable(3)

NAME
sdrtable - Simple Data Recorder table management functions SYNOPSIS
#include "sdr.h" Object sdr_table_create (Sdr sdr, int rowSize, int rowCount); int sdr_table_user_data_set (Sdr sdr, Object table, Address userData); Address sdr_table_user_data (Sdr sdr, Object table); int sdr_table_dimensions (Sdr sdr, Object table, int *rowSize, int *rowCount); int sdr_table_stage (Sdr sdr, Object table); Address sdr_table_row (Sdr sdr, Object table, unsigned int rowNbr); int sdr_table_destroy (Sdr sdr, Object table); DESCRIPTION
The SDR table functions manage table objects in the SDR. An SDR table comprises N rows of M bytes each, plus optionally one word of user data (which is nominally the address of some other object in the SDR's heap space). When a table is created, the number of rows in the table and the length of each row are specified; they remain fixed for the life of the table. The table functions merely maintain information about the table structure and its location in the SDR and calculate row addresses; other SDR functions such as sdr_read() and sdr_write() are used to read and write the contents of the table's rows. In particular, the format of the rows of a table is left entirely up to the user. Object sdr_table_create(Sdr sdr, int rowSize, int rowCount) Creates a "self-delimited table", comprising rowCount rows of rowSize bytes each, in the heap space of the indicated SDR. Note that the content of the table, a two-dimensional array, is a single SDR heap space object of size (rowCount x rowSize). Returns the address of the new table on success, zero on any error. void sdr_table_user_data_set(Sdr sdr, Object table, Address userData) Sets the "user data" word of table to userData. Note that userData is nominally an Address but can in fact be any value that occupies a single word. It is typically used to point to an SDR object that somehow characterizes the table as a whole, such as an SDR string containing a name. Address sdr_table_user_data(Sdr sdr, Object table) Returns the value of the "user data" word of table, or zero on any error. void sdr_table_dimensions(Sdr sdr, Object table, int *rowSize, int *rowCount) Reports on the row size and row count of the indicated table, as specified when the table was created. void sdr_table_stage(Sdr sdr, Object table) Stages table so that the array it encapsulates may be updated; see the discussion of sdr_stage() in sdr(3). The effect of this function is the same as: sdr_stage(sdr, NULL, (Object) sdr_table_row(sdr, table, 0), 0) Address sdr_table_row(Sdr sdr, Object table, unsigned int rowNbr) Returns the address of the rowNbrth row of table, for use in reading or writing the content of this row; returns -1 on any error. void sdr_table_destroy(Sdr sdr, Object table) Destroys table, releasing all bytes of all rows and destroying the table structure itself. DO NOT use sdr_free() to destroy a table, as this would leave the table's content allocated yet unreferenced. SEE ALSO
sdr(3), sdrlist(3), sdrstring(3) perl v5.14.2 2012-05-25 ici::doc::pod3::sdrtable(3)
All times are GMT -4. The time now is 05:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy