DSXchange

It took about two or three weeks for IBM to turn it round for our Windows install. You would kinda figure that if they fixed it in one OS they would have fixed it in all. Perhaps it is too much to expect a bit of proactive maintenance in this day and age.

Hi DJ

Google "IBM JR45546" to find the reference to this issue. It details the problem and the solution.

You will need a valid IBM support agreement to download the patch.

Cheers

Hi All We had this issue on our Window 8.7 Fixpack 1 install as well. We logged a PMR call with IBM and they have responded with a patch. The patch number is JR45546. I don't know if they have also provided a fix for Unix installs as well but this patch has fixed the issue for our install. Note that...

Hi All IBM have responded to this issue with a patch for our Windows 8.7 Fixpack 1 environment. The patch number is JR45546. I don't know if they have also provided a fix for Unix installs as well but this patch has fixed the issue for our install. Note that it is a server side patch only. Cheers Ga...

That's weird. We use 7.5.1, and have queries that are waaayyy longer than that, and we haven't had any issues... even with line feeds. I also have Version 7.5.1 installed on my laptop and like you it has no problems with long SQL statements. This looks to be an issue with V8.x but I just wanted to ...

Hi All I would like to know if anyone else has had issues with the number of lines of SQL that can be entered into the User Defined SQL tab of the ORAOCI9 stage in Server jobs? I have a Server job using an ORAOCI9 stage which uses a 40 line, formatted SQL statement in the Output User Defined SQL tab...

Hi there Piyu.

Did you ever report this problem to IBM and get a response?
I just hit the same issue with our install of V8.1.
Would appreciate any update you can give us.

Thanks
Gavin

I am sitting at home at the moment so don't have access to the exact source for the routine but it is basically along the lines of the following. Note the parameters passed are Arg1=JobNo and Arg2=JobName. The routine is called in a UserVariables Activity right at the start of the Job Sequence being...

Hi Ray / Craig Thanks for your input. I have managed to cludge together a routine which checks the RT_STATUS hashfile to see if the Checkpoint row has been set and this is giving me the answer I need for the time being. Have to say my BASIC skills are pretty rusty so it took longer than it should ha...

Hi all. I am putting together a restartable job sequence and would like to put in a process at the start of the job to detect whether the job is restarting after an abort so I can write this information to an audit record from within the job. The DataStage Director is able to natively detect when a ...

I'm not sure if this will be any help as I have not used it before but there is a routine in the Routines/SDK/RowProc category called "RowProcCompareWithPreviousValue". It looks like it will allow you to check the change of a key value as each row is read in and based on the output from th...

Hi All I have been asked whether DS can access data from MFGPRO or TIMS applications. These are application packages used by a manufacturing division of the company I am working with. I am told they store data in a Progress 9.1C database and a database called Appgen respectively. Has anyone used DS ...

Something else worth trying is to write your single records out to a work table in a database, then do a SQL select on the working table with a cross join to another working table with 10 rows in it. This effectively multiplies the input rows by 10. Have used this method in the past with success.

As a suggestion try defining the inbound record as a single wide field in the sequential stage, UPCASE the single field then split the result through a second transform using substrings [] commands. Just gave it a try and it works ok. Just have to be aware of quotes around any string fields and allo...