DSXchange

Try %SSS for the milliseconds bit - UPPER-CASE S not lower-case s, which is for seconds.

It means the library file vmdsapi.so is not in your LIBPATH or LD_LIBRARY_PATH depending which version of UNIX you are using. The file is I think located in .../InformationServer/Server/Dsdk/Bin. What you probably need to do before running dsjob is source the dsenv file, which should set up the libr...

I don't know why your bin directory has a VOC file in it - presumably created as Ray said in previous reply (but to do that there should have been a message first, along the lines of "do you want to make this directory an account" to which someone replied "yes") . On my 7.5.1 sys...

Does anyone know how to to start job montor on windows? One way is to run "jobmoninit start" from the PXEngine\java directory. In a command window, type something like: set APT_ORCHHOME=c:\ ... <wherever> \PXEngine e.g. set APT_ORCHHOME=C:\IBM\InformationServer\Server\PXEngine Followed by...

Going back to the statement earlier: We tried executing the script given by you in our server dssh.But we faced error after executing the below line COPY FROM NLS.CLIENT.MAPS WIN:1252,WIN:932 saying NLS.CLIENT.MAPS as invalid. ...we need to know the exact error message you got after executing the CO...

In a Transformer derivation expression, you could try:
That is, you prepend 10 zeroes to the start of your data, then substring the right-most 10 characters.

Syntax is the same in both Server and Parallel jobs.

OK, here are some instructions I wrote elsewhere for Japanese clients - can be adapted for Chinese, as explained below. Note that you only need to do any of this if you are connecting from a client whose codepage is set to, say 932, to a server that has been installed in English; on a version of Dat...

You need to have your client Windows code page set to 936 (for Simplified Chinese) or 950 (for Traditional Chinese) before the DataStage clients will be able to display or enter your Chinese characters correctly. On XP this is normally done from Control Panel/Regional and Language options/Advanced/L...

You have to decide what date you would substitute for a null value. For strings, the empty string ("") is an obvious choice for null, and for numbers 0 is fairly obvious. But for dates you need to pick something like "1900-01-01" if you really must treat null as if it were a defa...

This is often caused by a failure to load the JVM on the client due to insufficient memory. If you look in C:\IBM\InformationServer\ASBNode\conf there should be a file "proxy.xml". It should have a line that reads something like: <add key="MaximumHeapSize" value="384" /...

This is often caused by a failure to load the JVM on the client due to insufficient memory. If you look in C:\IBM\InformationServer\ASBNode\conf there should be a file "proxy.xml". It should have a line that reads something like: <add key="MaximumHeapSize" value="384" /...

It's what implements the Data Set Management tool you get from the Manager Tools menu (Designer at DS 8.x). That can be used to examine dataset/fileset objects you can create in Parallel jobs.

Trouble is, "dsjob -import" only imports the job executables, not the design-time metadata. So "dscc" would not be able to compile a job imported that way, as there is nothing to compile. As of DS 8.1 there is a new server-side DSX import service that will run on Unix as well as ...

DSR_JOB (Action=9) is the "job upgrade" action that is called during import of a job from an older version of DataStage. It sounds like there is a problem with the format of one of the jobs in the DSX file. If there's more than one job in the file, I can only suggest trying to narrow it do...

DSR_JOB (Action=9) is the "job upgrade" action that is called during import of a job from an older version of DataStage. It sounds like there is a problem with the format of one of the jobs in the DSX file. If there's more than one job in the file, I can only suggest trying to narrow it do...