DSXchange

When the process is sitting in sequence B, are there any other jobs running according to the director? Also, do you have any after-job subroutines - those sometimes have some sort of wait built into them and can make it look like a job is hanging. Thank you for the response as far as I can tell not...

I have a sequence, lets call it A, that calls 2 other sequences, lets call them B & C, made up of parallel jobs and then loops them based on a parameter. It will execute but it takes almost an hour for the next iteration to begin. All the individual jobs take a few seconds to a couple of minutes...

It appears I can create multiple schedules, as long as I select Every or Daily. But if I try to add more than one of usng NEXT, Tomorrow, or Today...it will not allow it.

Is this the expected behaviour?

I added a job to the scheduler. Then I want to add another instance of that job to the scheduler but nothing happened..it took the input but only showed the first instance I set up. No error messages as far as I can tell. This was against a sequence job. Is this a bug or is there some setting to all...

hitting the ESC key canceled and reset the properties window. I was then able to call up the properties window again without incident. I also learned that the register entry for this is: HKEY_CURRENT_USER\Software\Ascential Software\DataStage Client\Designer\APTStageEditor\CCustomStage.PxFTP Deletin...

I was working a parallel job which has a file seq to an enterprise ftp stage. I had working and wanted to make a change. I right click and hit properties on the FTP stage. The window never appears and the designer locks up. I have rebooted my machine, started a new job and can open a properties wind...

I have a piece of code that I am trying to implement in DataStage. Is it possible to achieve the same effects as the code by using DB2 UDB or DB2 API stages? Here is the code : db2 +p -v +t -s -o >> $TMPFILE1 << EOF connect to $DB2_INSTANCE user $DB2_USERID using $DB2_PASSWORD import from $EMPTY_FIL...

Ray, thank you. I had the code in the start loop activity rather than in the
Sequence job activity. Once I made that change it all worked. Thank you again for your patience and help.

You should be passing just a value, not an assignment statement. Get rid of the "PN = ". I apologize, I should not have highlighted the following in code, my fault. Code: PN = Left('0000044H2790' This was suppose to be the output from the director on the job parameter, showing that it was...

Ok here is a link to the job report:

http://ipd.bravehost.com/loop_test1.htm

This might shed some light on my problem...thank you.

Thank you Ray, I understand what you have suggested but we either have a bug or something else. If I use your statement in the start loop activity which I believe is where this would go, what gets past to the job activity is PN = Left('0000044H2790' so its finding the input from the file but everyth...

Still need help: If I modify the file for the cat command to: '000000000001','000000000002','000000000003' and use comma delimited in the loop it will work until the last record. if I add an extra , to the end: '000000000001','000000000002','000000000003', it thinks there are 4 entires and aborts o...

Ray, Thank you very much for the information. This has helped me a lot but I still have one issue and I believe it is centered around the delimiter in the file. Here is what I have done: If I use your suggestion on the CHar(10) [by way we are on AIX but I think it is the same], the loop tries to pas...

Ok I have some ideas on what has been said and view some other topics but we are new to datastage and need a little hand holding, if you don't mind. I read the loop documentation but it's very basic. So this is what I tried to do: I have an execute command step that simply cat's a file: cat /sail/u/...

We noticed something very unusual about a very simple datastage job that we need some clarification on: We have a datastage job that consists of a sequential file going to a DB2 UDB API stage, where it it is doing an "insert rows without clearing". The SQL is generated INSERT INTO TORELLA....