DSXchange

Michael, The job looks like this Seq-->Xmr-->seq-->Xmr-->IPC-->Xmr-->Seq Each transformer does a couple of lookups in to hash files/odbcs. Inter process row buffering is enabled. All the 13 jobs are physically 13 different jobs to datastage , but they do exactly the same functionality.We are not usi...

i think the following should work. but make sure you have back up copies of your job before attempting it. 1)export the job as a xml file 2) write a pgm to traverse through the xml file and replace the value of "derivation" property of collection "columns" for the required stage ...

Neo,

trim the Name field before you write in to the hash file. Also use the trim function, before looking up for the name.

HTH
Dhiraj

Hey Peter,

The only compelling reason is that our clients are particular about it.


Dhiraj

We were running 13 jobs concurrently. each processing about 10 Million records and running for several hours. These jobs read from sequential files, do multiple lookups in to ODBCs and hashfiles and finally write the result in to sequential files. The jobs run real slow and some times some of them a...

craig, 1) If you are bulkloading in to all the columns of the table and your file contains only the columns which are present in the table and your file is a delimited file and your file is a character file ( no packed decimal or binary data) then you do not require a format to bulk load using the s...

the code given below should reset the specified job.

I am trying to do this in Xfm but I am not getting the required values. What are you doing in the transformer? I mean how are you trying to implement this? what are you looking up into? An ODBC? if so you could use the user defined sql option in the ODBC stage and specify the relational condition y...

If the output file produced by your job is in sorted order of the quarter number, then use an after job routine to do this 1) read the first rec from the file and write it to the output 2) read the next rec and compare the quarter number with that of the previous record. if not in order you expect, ...

this should be even faster

Dhiraj

Hey Xanadu, You could land your target in to sequential file and then use the db2 bulk load stage to bulk load the file using the DB2 bulk load stage. set the load type property to REPLACE. If you do not want to land your target in to seq file then bulk load an empty file first and then run your job...

1) Is 'DEPENDS' some kind of reserved word. i.e is the code given below equivalent of what u've given? INSERT INTO DICT DS_JOBS (FIELD, CODE, EXP, NAME, FORMAT, SM, ASSOC) VALUES ('DEPEND_TYPE', 'I', 'RAISE(TRANS("DS_JOBOBJECTS","J\": @RECORD<5> :"\ROOT",32,"X"...

I have a job that calls a stored procedure using an odbc stage. This stored procedure is invoked multiple times(a few thousand times) by the job. When i run this job i get an error message stating invalid cursor state. This stored procedure has statement as shown below. select 'MYMessage' When i rem...

I have a sequence job, which executes five server jobs in parallel. An external scheduler triggers this sequence job. Now if one of five server jobs abort ,and rest run to completion. when i restart the sequence job it will run all the five jobs all over again.How can i restrict it to run the aborte...

can you please explain what the 3rd dictionary item means?

INSERT INTO DICT DS_JOBS (FIELD, CODE, EXP)
VALUES ('DEPENDS', 'PH', 'DEPEND_TYPE DEPEND_JOBS');

Thanks

Dhiraj