DSXchange

One way of making your existing jobs read only is by messing with the dsx export file. In notepad you can do a global replace on ReadOnly "0" to be ReadOnly "1" and re import the file. This method is of course not sanctioned by the vendors and I doubt if they would give you any s...

Yes, we are running 4 way.

Got a solution to our NEXTVAL lookup problem. It requires two DB2 enterprise edition sparse lookups with identical sql i.e. SELECT IBMREQD, NEXTVAL FOR DM01.CDM_ARR_ID AS NEXTVAL FROM sysibm.sysdummy1 WHERE (IBMREQD = ORCHESTRATE.IBMREQD) The column IBMREQD is alternately set to 'Y' and 'N', and the...

The reason we had to hand code a NEXTVAL in EE for use against DB2 was that DB2 just gave us 1 single value for nextval, i.e. it didn't sequentially generate itself as expected. e.g I expect a sequence of values 1,2,3 but got 1,1,1

We faced a similar issue with NEXTVAL from DB2 in EE. My workaround was to have a text file called NEXTFILE and write some basic to READSEQ the value and pass it down to the job as a parameter. The job itself now has an aggregator which outputs the max value of StageVar NEXTVAL which is simply a cou...

I had a requirement to load data from a spreadsheet into unix. I wrote a macro to select the area I wanted out of the spreadsheet and saved it as a csv. This was then ftp'd to unix. Easy.

Have you specified which korn shell you're using at the start of your script? I had to set mine to:
#!/usr/bin/ksh

Usually you gets *'s when the date is null or in the wrong format. I hope you are using varchar(11) rather than char as this will introduce a null filler into your data unless you've set $APT_STRING_PADCHAR= space

Post an example of the date you're trying to convert if you want any more help.

You could always divide by 0 if you want a quick failure.

handle_null seems to be the way forward here, but in the PX developer pdf, they have a NullToValue example under the modify stage. Surely this function should be available? I'm happy with the work around.

If you're brave enough, you can write a basic routine to automatically update your DSX export file, so every DB2 plugin is changed to an Oracle one. I did this recently upgrading an oracle 8 to 9 system.

Best take a backup first...

Arnd - Ja, you're right, its been a long time since I've seen blink and flink errors. What do you think about creating a new project and abandoning this one?

Bad forward link found

This is an overflow error probably caused by a bad sector on your disk. I'm doubtfull if you can recover from this.

If you have a recent export, I'd consider abandoning this project & creating a new one. Looks like your hard drive is about to fail some time soon.

Stage variables are useful here to concact data together. You can set stagevar2 as your source ID and stagevar1 as stagevar2 and compare the differences (stagevar1 created before stagevar2) I'd send the data to an aggregator and with the 'last' option selected rather than landing to a hash file, thi...

We recently used MQ messages as a scheduling option, i.e. the Oracle backup placed a message on the queue to say it had completed. This allowed as to create jobs with a non destructive read, allowing us to wait for the message to appear. Two or more sequences could then be run in a "wait state&...