DSXchange

Hi All, I am trying to find the advantages / disadvantages between using Job Sequencer available in 8.1 and using (unix wrapper script + Autosys) Combination. I did find a topic regarding this, but that is way back from 2005, when Job sequencer might have had limited capabilities. http://www.dsxchan...

Hi, We have a datastage job which reads from the TD and Writes into DB2. TD Connector -> DB2 enterprise stage. The DB2 enterprise stage looks like this: Write Method: Load Write Mode: Append Non - Recoverable Transactions: True We find this DB2 write part to be very slow. We tried creating a Sequent...

Thanks tehavele!

But does the 'Truncate' load method in DB2 enterprise stage, actually issue a 'delete from <table>' command behind the scenes (mean it is logged transaction)?

Thanks
Venkatesh

Hi All, Does the 'Truncate' load method in DB2 enterprise stage, issue a 'delete from <table>' command behind the scenes (mean it is logged transaction)? Or does it do a non-logged delete? If it does a logged delete, then is there a way to do a truncate of the table before loading it from DB2 enterp...

Thanks John, Ray and Craig. Yes, the dsx file does look a little simple than the xml file. But the only difference is the representation the almost both of them contain the same amout of code and same number of lines. But that is fine, I took dsx now. I think we need some more understanding on the s...

John, Thanks for your reply. I did take a sample DB2 and Teradata jobs and compare. But the xml is not that simple and straight forward. What if the DB2 stage is not the first one in the Job. Then we can look for V0. Also, There are many tags for which we need to know the meaning even before we can ...

We have to do a mass replacement of DB2 stage in our ds jobs to Teradata stage.

Are there any automated ways to do this?

I was wondering if there is anyway we can manipulated the exported xml or dsx files.

Any thoughts?

Hi All, I have a Sequencer (DS-SEQ1) like this: DS-JOBA --> CMD-B --> CMD-C --> CMD-D DS-JOBA => DS Job Creates 3 sequential files CMD-B => Loads File1 CMD-C => Loads File2 CMD-D => Loads File3 I have 'NOT CHECKED' the 'Do no checkpoint run' box in any of these activities in the Job Sequence. I call...

Hi All, I have a requirement to read a BUFFER (CLOB) field from a table in DB2UDB. The field is a complex 3000 bytes field which has various information is written in key-length-value format. i.e.: KKKKLLLLVVVKKKKLLLLVVVVVVVVVV..........................etc till EOL where K - Key (4 chars) L - Length...

Hi All, I am developing a parallel job which need to perform a lookup on a huge database table. The lookup involves 2 key columns and 1 data column (about 30 bytes in total) and about 10 million rows? What kind of lookup mechanism is advisable for this job? How can I decide whether to use a ODBC loo...

Hi Meena, Thanks! But I already tried this and I faced a problem: If I take the same set of data I mentioned before, RefA1, RefB1, RefC1 RefA1, RefB1, RefC2 RefA1, RefB2, RefC1 RefA1, RefB2, RefC2 RefA1, RefB3, RefC1 RefA1, RefB3, RefC2 If I write this into the hashfile, I will finally have only one...

Even that is not possible, I guess. How would I know what rownum to look for in the hashfile?

Kris, Thanks for the response. As you say, if I create a hashfile with a dummy key column, then what will populate that column inside the hashfile with. Say if I populate a constant value (eg. "*") then, I guess I can have only one row in the hashfile. Am I right? I have various different ...

Hi, My reference (lookup) file is having the following columns: RefA RefB RefC RefData1 My data (source) file is having the following columns: SrcA SrcB SrcC The lookup i want to perform is like this: If (SrcA = RefA) AND (SrcB <> RefB) AND (SrcC <> RefC) Then I need to pick up RefData1 If I build a...

Hi,

I have a multiple instance job. If I am running it from the unix using dsjob command, can somebody tell me how should I supply the invocation Id.

Thanks in advance.
Venkatesh