DSXchange

You can also clear the log from Director without viewing the log itself - select the job and then in the job menu, select clear log. I just had to do that for 400,000 entries

Thanks everyone, I hadn't used WEEK.TAG before

Thanks Arnd

Hi, is there an easy way to obtain the week number in year using Oconv (1 to 52)? (I know that I can use Oconv(Arg1, "DW") to get the day of the week as a number). I could probably work this out using stage variables and sequence numbers, but I was just wondering if this was possible. Thanks

I always clear the derivation column info in the DB2 stage when connecting to DB2 on AS400 (not sure about the ODBC stage). If you did this to your ODBC stage, you SQL would be as follows: SELECT IDEPT,ISDEPT,ICLAS,ISCLAS,DPTNAM,DPTSHT FROM DEV2LIB.INVDPT I work currently in an AS400 environment, an...

Thanks Arnd and Craig, amazingly quick replies!

Arnd, I'm in the process of setting up a .bat file to automatically create backup files of my projects, but I'm not sure of the syntax for putting a date/time as part of the filename. I would like to have "projectname YYYYMMDD .dsx" How did you do this? Surely this is straight forward, but...

Hi,

From my experience, you must keep your AS400 library list as small as possible, and then be patient. Importing metadata can be very slow from DB2 on AS400. File are seen as tables on AS400, and there are typically 1000's of the damn things! Good luck.

Craig, I have noticed that many people have experienced problems with the link collector stage, when enabling inter process row buffering (ds_ipcopen() - Error in open). Have you experienced issues with this method? My workaround was to not use any row buffering, instead I write data to multiple seq...

Hi Luk, try @OUTROWNUM <=5 in the constraints area of your transformer

It is actually possible to merge two streams without using files as buffers. I always use files to source and collect my data, but a quick read of the documentation tells me you can use inter process row buffering. You can find this option in the performance tab of the properties page to enable acti...

Hi Luk, It's possible to aggregate data in the derivation part of the output of the link collector.

Hi Luk, you can use the link collector stage. This allows up to 64 inputs, and then outputs as one single stream of data.

Glad to hear it. I think it was the easiest solution to get to grips with!

Do a search on the internet for the oracle error "ORA-00904". This should give you some clues as to the error you are getting.