DSXchange

Arnd

I think the trick is in VB when you call a routine. I think it is easier there.

It is a Pick command not Prime. Sometimes it pays to be a Picky.

Craig is correct. The newer date types added milliseconds and some of the routines break. DataStage itself may not handle a new data type on a new release of a database. You may have to use varchar in that case.

I think varchar on both ends works great. It stores it internally as varchar anyway. DataStage itself is faster in a server job to use varchar on most everything. You only need the real type on a plugin like a bulk load. DataStage will handle the conversion at that point. PX jobs are very different ...

Use convert() it is faster than ereplace(). It does not do as much but is very good for this type of thing.

I would say your metadata is messed up. You may need to delete the hash file and recreate it.

CNAME is the TCL command to change a file name.

Craig is correct. You need to build the hash file with some arbitrary key. You need to use a UV stage unless you can find and build multivalues. Save your metadata from the hash file load. Leave the hash file in the account (no path and no account name) unless you want to figure out SETFILE. Next us...

Yes you can. You can easily do it with 2 transforms. If you want to do it in one transform then the order is important. Next you have to manually type in the field or fields in the lookup columns of the second lookup because it will not let you drag a column from the first lookup. It will also leave...

The answer is so judgemental

The best answer might be that SAP, PeopleSoft and some of the biggest software companies use DataStage and include it with their products. If it was not at least as good then why would they switch from the other to DataStage.

You need to shell out and unzip it before processing it. Write a shell script or a batch file in DOS.

I think I have. Search for it.

You can change it to ExecSH or ExecDOS and it works fine in all versions.

Command Stage serks.

Do a search for DSGetJobInfo

http://www.dsxchange.com/viewtopic.php? ... getjobinfo

Write one routine which calls the other 2.