DSXchange

Wow, thanks Vincent. Wasn't expecting anything quite so... complete. Some of the Client side quibbles could be rather major for us - especially the apparent change in the license tracking. Is this acknowledged as a bug? I recently had to install the MCM on my work laptop for a PX class, needing the...

Is your date field reliable, guarenteed to be a valid date? If so, you could just substring it:


Otherwise, you will need to use your old friends Iconv and Oconv.

A question for the recent upgraders out there - is the most current version of DataStage Server 'stable'? I seem to remember seeing posts here and on ADN where people were having numerous problems after upgrading to 7.5.1. I believe patches were made available to solve some (but not all?) of the is...

Search the forum. You're not the first person seeking this information. For example... here.

Technically, any valid UNIX command should work in the Filter. By default, you get a string (alpha numeric) sort and you have to use the -n option to force a numeric sort. This should all be spelled out in your man pages. I don't know if it's valid to use Job Parameters in the filter, I've never tri...

The Filter can take any O/S command that handles Standard In and Standard Out well. Sort should be one of them. There is a bug in the version I am running (7.0.1) where filter commands with quotes or pipes get stripped after the first occurance. You can see this by typing a filter command in the sta...

Also how does it assist in migration of code across projects? Pretty obvious, if you ponder it for a bit. Since leaving it blank equates to the current project the job is running in, this means you can move the job from development to test to production without having to touch the Account Name the ...

I have this requirement where I have a column named rowid_id which holds the value of rowid of the record. This is a... strange... requirement. I have no idea what value you would bring to the table by pulling the ROWID out into a data field. However, it can be done. Keep in mind the fact that ROWI...

Um, what? You might want to try asking again.

The compiled code from a server job is not executable by the native machine; rather it is executed in a 'virtual machine' called the DataStage Run Machine. This assists in platform portability, and explains why you can't install an AIX DataStage on an HP-UX machine; the Run Machine is different. It...

As long as 'upload' means 'install', it's all spelled out in the readme file that ships with the product. Between that and the Installation and Upgrade Guide you've got everything you might need to know about installing the client software. Besides, there's not much more to it than making sure you'...

As long as the hash file is in an 'Account' or you've established your own VOC record for it. For an unadulterated Pathed Hash you can't count it like that. I'd be curious to learn what the 'certain logic' is you'd need to do if the hash file is empty. I've never had a need to worry about this in al...

I have DataStage 7.5 on a Windows 2000 box with Oracle 9.i client. Connecting to an Oracle 8.1.7 database on a Unix box. Just for the record, I'd be curious what exact version of the 9i Client you have installed on the DS Server. I'd also be curious about the possibility of installing an 8i Client ...

And just to finish beating this little horsey...

If you are running the job outside of the GUI (via 'dsjob' for instance) supply the Invocation ID as a 'dot seperated' value after the job name. For example, run 'Jobname.ID' rather than 'Jobname'.

Just make sure your ToDate parameter data type in the DS job is String, because Date has a required value at runtime. Ken makes a good point about the usefullness of the CASE statement, so you could go that way if you are comfortable with that syntax. Only wanted to point out what I quoted. I've do...