DSXchange

I've implemented the End of Message technique and it has worked without incident for 6 years. It would require two jobs; one to put the stop message onto the queue and one job to take it off. It is elegant and simple and for those reasons also robust.

I admire your notion of bulky and lengthy. Clearly the smart and efficient methodology would be to update your resume.

Just to completely beat this to death and then set it on fire, a colon is not allowed in a Windows filename.

Server - works EE - Doesn't work because of the colon. A hardcoded test of a Sequential file name that contains a colon throws the same fatal warning; Sequential_File_15: When processing argument -fileWhen processing path: /tmp/todd:todd.csv is not a valid path name: Invalid hostname: /tmp/todd and ...

My AIX 5.3 doesn't care about the colons. It appears to be EE. How about your EE?

That doesn't work on UNIX 7.5.3, neither does #DSJobStartTimeStamp# for this reason; Sequential_File_15: When processing argument -fileWhen processing path: /tmp/2009-02-18_07:55:25.csv is not a valid path name: Invalid hostname: /tmp/2009-02-18_07 Are you saying it works on 8.x or yours (rony_danie...

Here's one way;

But carries baggage of it's own which may be too heavy. Like, an After routine is already defined for the job or such a simple task as renaming a file seems overly complicated to do it in two places, one fairly hidden in the GUI. I like using a DS Macro for this; #DSJobStartDate#.csv Everything has ...

He wants -89.62 but is getting zippage. Will max() work with a decimal?

You need to define the proper path for $APT_ORCHHOME. I'm not sure what it would be for Windows but here's my UNIX; dev:echo $APT_ORCHHOME /etl/dev/DataStage/PXEngine dev:/ADM/oracle/home/z901464: You need to find where your PXEngine folder resides on your DS Server and map the environment variable ...

I've never used this function and if I had a dime for all the times things "have to work" but didn't I wouldn't be sitting here writing this. I have, however, used the help button in Datastage. To wit; Max Returns the greater of the two argument values number 1 (int32) number 1 (int32) res...

Stage Variables in EE are NON-NULLABLE. ##E IIS-DSEE-TFEV-00026 04:19:46(006) <transform> Error when checking composite operator: Setting null to this non-nullable field: StageVar0_StageVar2. They cannot contain a value that might be evaluated to NULL. For some reason the Compiler is smart enough to...

Kiran259 is mistaken. You can run the SQL from the command line. Do a search for dssh or uv.

DS Help would have answered your question faster; Seq(character) Converts an ASCII character to its numeric code value. Syntax Seq(character) character is the ASCII character to be converted. If character is a null value, null is returned. Remarks The Seq function is the inverse of the Char function.

You are attempting a two-phase commit. Read from MQ and write to DB2. The ways that can not work but report success to the transaction are many. There is no way I would trust DataStage or my programming prowess to catch them all. Rather I would keep it simple. Browse from MQ write to DB2 and then go...