DSXchange

Craig, that is very kind of you.

I'm not supposed to be a developer anymore and tend to stick to ETL architecture but this job tickled my fancy (i.e. no-one else would do it).

I'll try what you suggest and let you know ( hopefully before I am blindfolded again!)

Yes, Craig. It shouldn't have compiled. I can't read the rest of your message as I am a lapsed member :oops: , but I am assuming you are saying the only way to loop is to use the looping method. I am now thinking along the lines of using the looping function in the transformer but I haven't quite go...

Thankyou for pointing that out qy_ky.

This means that it is never possible to do this sort of job in Datastage i.e. recursively until a condition is met.

Have you ever managed (needed) to do this ?

Interesting point Ray. I actually wrote another sequence specifically to test the functionality of the line count and made sure that it worked when the file created was empty (i.e. 0) and when there was one line. The NES_NEW_LINE actually gets run once as the process initialises and completes one ci...

I have created a job sequence with a non-standard loop (i.e. not using the StartLoop and Endloop functions) I have had to implement the loop this way as it is a recursive style and should stop only when a certain condition is met. I have two entries to the SQY any sequencer; the first is an initiali...

I have extracted all my reference tables into datasets and created them with keys in hashed partitions for the joins that will be used with them. Additionally, I have sorted the data too but am unsure if it is really worth it given that the source data I will be joining with may not be sorted on tho...

Hi I am working as an DS architect for a french firm. We are putting in a DS framework from a local supplier and in the process of moving a small number of high volume server jobs to PX. The quality of the jobs and data is variable and knowing the PX is fussier with its treatment of data than Server...

Hi, I am working as a DataStage architect for a French firm. We are putting in a DataStage framework from a local supplier and in the process of moving a small number of high volume server jobs to PX. The quality of the jobs and data is variable and knowing the PX is fussier with its treatment of da...

Hi

When I do a SELECT FROM TABLE WHERE ROWNUM < 1,000,000 on using parallel partitioning I get 2,000,000 lines returned (2 node) for hash and round robin but for rowid it returns 1,000,000.

Is this normal ?

Thanks

Colin

Contrary to my belief that the license was not an issue,having now installed a new licensed version, the jobs now compile

I put them under the Compiler options in Administrator Client

Thats the strange thing, other jobs compile, just no new jobs

I dont think its a license problem yet as it expires on the 7th July. However I have changed the compiler flag but still get the same errors IIS-DSEE-TFCN-00006 16:09:19(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=sr052137cti3700; -m=00CF55A64C00 ##I IIS-DSEE-TOSH-00002 16:09:19(002)...

On any new job I create with a transformer, I am unable to compile it Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 15:34:07(000) <main_program> IBM InfoSphere DataStage Enterprise Edition 8.7.0.6614 Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved ##I IIS-DS...

Hello,

Does anyone know where I can get hold of a utility that will analyse a DSX job by job to give an idea of its complexity (number of stages, transforms etc etc)

Thanks

I checked with the DBA. For the Siebel databases, they are configured in Unicode whereas the other non-Siebel aren't. From memory, altering the NLS_LANG wouldn't actually have any effect on the database. I'll do a search and see if there are Oracle/Unicode workarounds (unless you have any other idea...