DSXchange

adisheshu.dwh - you have managed to break an incredible amount of DSXchange forum rules and recommendations in a single post. - Please post meaningful subject lines, "HI" is not a good choice. - You posted in the "FAQ Discussion" forum, which is meant for frequently-asked-questio...

There will be more error message that are more helpful than the one you posted. Do you mean a different DataStage userid or a different Database userid?

Why not use the derivation of "CurrentTimestampMS()", that works for me.

Craig - you got it correctly, the BASIC stages will only run on a node where the engine is installed; I missed that the original poster is running in a distributed environment.

You will need to declare your Timestamp column with the extended attribute of "microseconds" in order to store fraction seconds.

Is there a dsrpcd process running on Box2? Have you tried to connect to "Box2:9080"? Just enter the domain, userid and password and click on the dropdown list to see if the connection works.

Strange that the posts are being "cropped". Basically, I think you need to use Box2:9080 instead of Box2:31538

What is the date modified of the ""/opt/aCC/include_std/iosfwd" file? Did they change the compiler yesterday or install a patch to the OS (or DataStage)?

Not permission on the node file, but permissions to the nodes referenced by the file (the fastnames).

I just tried it with DataStage 8.0 on AIX and my output file contained the output of the command. What OS are you on?

I think that IBM support is going to ask you the same thing that Craig just did. Try to write a simple job with a pass-through BASIC transform stage and see if you can get that to run.

Premium membership dues keep the site alive; whether or not you sign up depends upon the value you place on the forum for your use.
But in this case I've marked my previous post to be visible, since the quoted text used up all the "free" words.

octogun wrote:...
DataStage Repository Interface
Failed to connect to DataStage Server:
Box2:31538, project uv
username and/or password incorrect 80011
...

I just saw this - I think you should be entering your "Box2:9080" instead of "Box2:31538"!

Do other jobs with transform stages compile? If "no", I would suspect a bad compiler version or bad compiler installation. If "yes" then you might have become the unlucky owner of a newly discovered bug.

Are your two examples done by the same user in the same session? Have you checked the contents of the "Temp" file without a "grep" to see what actually gets put in there?