DSXchange

Because you've haven't done all of the proper steps to prepare for it. The posts here that you took the 'cat' command from would have listed everything that needed to be done, including the 'sourcing' of the dsenv file which it looks like you missed. From the $DSHOME / DSEngine directory: . ./dsenv ...

Another interesting observation: In spite of logging onto the box and running all jobs as our normal 'runtime' userid of 'dsuser', they in fact now run as dsadm instead. I would really appreciate any suggestions on things I can check to determine what in the heck is suddenly different about this ins...

But of course!

Did you check the docs so you have the format of the file correct? I don't have it handy, but it is documented and something like this off the top of my head: server,userid,password And you still have to specify the -server on the command line so it knows which record in the file to use as it suppor...

Two question mark parameter binds means only two columns can be in the stage. To do what you want, remove the ID column from the stage and only mention it in the insert statement.

Me, I wouldn't and would use a BI tool for that, not an ETL tool... but that's just me. To get help on this, first I'd suggest that you explain what 'GROUP BY CUBE' does exactly rather than expecting everyone to be familiar with it already. Or forget the sql specific syntax and explain in words your...

Welcome! :D

The only way to 'hide' that I am aware of is to use the "-file" option. However, some people find this unacceptable as it requires the server,userid & password information to be read from a plain text file on the DataStage server.

I do believe that Ray actually meant the ".odbc.ini" entry.

That should be DSSetJobLimit and you'd have to write your own code to 'launch' the job to use it. That or use 'dsjob' with the '-warn 0' option from the command line in an Execute Command stage.

Where were these records being written? Any chance you ran out of space where DataStage is installed?

Please try searching the forums for '39202', your error number. I got a number of hits, several of which looked like they could help. For example:

http://www.dsxchange.com/viewtopic.php? ... ight=39202

Double-click on each routine in the Manager and read the Long Description and/or the code to see 'how to use'. A Routine Actitivity stage is the answer to your 'in DataStage Sequences' question.

Welcome! :D

You need to determine the ASCII value of this 'special square character'. Ask your DBA or perhaps output the data to a flat file and use a hex editor on it. The the CHAR() function can be leveraged to change it/them to a pipe.

Quod erat demonstrandum, baby.

It is something that is either emailed or otherwise made available to you by IBM when you purchased the product. If you've lost it, you'll need to contact them again.