DSXchange

If you how to script above senario. Please let me know. \
Thanks for your concern

ray.wurlod wrote:Generating how? What are the specifications?

Hi,
Rec_types means P0001, P0002.....etc

Hi i am getting data from the database table and i am generating the rec_types

cat A B C D > E Do the files have header records? Yes Example : How can we a shell script and pass date parameters .I have 3 files comming from Datastage with |" delimited I need append 3 files as above: File1: P0000|"47416954|"AU|"000|"INS|"0000|"|"20060601|...

How can we a shell script and pass date parameters .I have 3 files comming from Datastage with |" delimited I need append 3 files as above: File1: P0000|"47416954|"AU|"000|"INS|"0000|"|"20060601|"99991231|"|"|"|"|"01 File 2: P0001...

Hi, we have followiing output files: FileP0001 REC_TYPE,EMPNO,LOCAATION, ACTION, P0001,1234,MI,Hire P0001,2234, MI, REHIRE P0001,2345,US, Termination File P0002 REC_TYPE,EMPNO,BASE PAY, JOBTYPE,EFFECTIVEDATE, P0002, 1234,4000,S,12/31/2006 P0002,2234,30000,H,09/30/2009 Bascially i have 40 REC_TYPE Fi...

Hi, I got 2 ouput files with different stuctures. I need to append in to one file . and sort it based on COL2 and COL1 Please let me know: Example: File 1: P001,101, US P001,102, MI File2: P002,101, XYZ,234354432,loc,12 P002, 102, XYZ,43543,loc,13 I think it should be possible by unix scripting. If ...

Hi,
I am getting 4 files and i need to append them into a single file in UNIX
Please can anybody give sample UNIX script code

Hi, I have a requiremnt. I need to merge 2 different table structres into single file with Rec_Types. Example: i have 2 source tables in Oracle database. 1. EMP Tables(empno,ename,email,phone..) 2.Dept Table(Empno,dname,Location Col's) I need to genrate the following sample output format: Header|emp...

But how to do keep te conditions for that in the job sequence

Hi, Please anybody can help to write a store procedure for extracting data from source in datastage 8.5

Hi, I have the error handling things in Datastage Jobs. When we we create sequencer it should throw errors and insert into the table These are the following situations when it find error 1.Source File Not Found Action : Error record should be generated And inserted into a table/ 2.Database connectio...

I need a shell script. A UNIX shell script consolidates all the Error files generated by one or more ETLs for a given interface into a single Error File.
Ex: Error file1 , Error File2, Error File 3 etc All need to be consolidated into one error file using Shell script