Data stage - UNIX

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Data stage - UNIX
# 1  
Old 12-10-2013
Data stage - UNIX

HI I am a datastage (ETL) developer , i have sequence and it has got one job to run , by using UNIX / Shell script , i have to find " after running the job in sequence successfully , i need to find whether it has inserted any no of records into the table or not "? both source and targets DB2 tables , please help me out
# 2  
Old 12-10-2013
This is a bit vague. What do you mean by sequence and having one job to run. This sounds like you need to run something and test the success of it. What do mean by find...are you trying to look for a process? Please clarify. Can't you query the tables before and after? Is there a transaction log you use?
# 3  
Old 12-11-2013
DataStage developers can easily understand what is a sequence , but i try to explain , sequence means set of data stage jobs and they will run one after another in an order. and each job will fetch data from a source and process it according to the requirement and finally will load data into target using sql query most of the times.

so my requirement is , after running a sequence i need to find whether any rows are inserted into target or not.

my source and target both are DB2's
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run the Script from any stage by updating data from Oracle Table.

I have 100 Scripts, each containing 10-15 SQL's in them. Each Script run for 40 mins to 1 hour 30 mins. In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the... (7 Replies)
Discussion started by: kiran1992
7 Replies

2. SCO

FATAL BOOT ERROR: Canít load stage 3

I'm under huge pressure to recover data from an old server that only gets booted very infrequently. The data on it is urgently required - isn't always??! .. Server is an HP DL380G5 which is running SCO Unixware 7.11 .. It has 3 partitions in a RAID 5 Configuration: 1 of 10GB (I assume it... (19 Replies)
Discussion started by: BernP
19 Replies

3. Solaris

Pre-hardening stage - automate or manual

Hi, Just before I begin I thought I'd ask the experts. I have a long list of task to pass along to my ldom and zones. is it possible if I make the changes in the LDOM to pass it along to the zones as well? or do I need to manually do everything? (0 Replies)
Discussion started by: techy1
0 Replies

4. Shell Programming and Scripting

I want a script to view the complete log information of data stage job from UNIX IBM AIX.

Hi, I am working on data stage 8.7 version and I want a script a to view the all log information of the data stage job from UNIX environment. Can you please help me out by give the script. Thanks in advance... (7 Replies)
Discussion started by: victory
7 Replies

5. UNIX for Advanced & Expert Users

grub loading stage 1.5.

Hi people,I am trying to install Debian Lenny Betta-2 on a system that has the built in promise chip for "Raid 0" but when I finished the install and then I reboot ,I get "grub loading,pleas wate... Error 2. also the Debian Lenny Betta-2 is identifying both drives ,instead of a singular drive... (4 Replies)
Discussion started by: thegreatalsky
4 Replies

6. UNIX for Dummies Questions & Answers

Validating XSL sheet data in Unix Data file

Dear All, Need your help. In my day to day activities I have to validate/search Excel Sheet data (eg.say Application No. 0066782345) data into the Unix environment file whether the same data is present in that file or not. There are hundreds of records coming in excel file and I am doing grep... (1 Reply)
Discussion started by: ravijunghare
1 Replies

7. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

8. UNIX for Dummies Questions & Answers

Multiple stage file move?

Greetings all. I need is a script that will move a file from one known dir to another, then grab another file from a different dir to replace it, and have absolutely zero clue how to do this. Here's what I am trying to do: A web client wants his site header image to change based on US... (2 Replies)
Discussion started by: ccvortex
2 Replies
Login or Register to Ask a Question