DSXchange

Please post the exact error message that you are getting so that we know where to start looking for the cause of the problem.

The sort stage gives you more options and control.

DataStage server internal dates are Julian; so an should give you the numeric difference in days.

I use MQJExplorer a lot to explore and modify MQ contents. The UNIX command line utilities can also be used, I don't recall the exact commands but they can be found in the MQ /bin directory.

You are probably doing an insert-then-update instead of update-then-insert.

Can you connect to the queue manager from the command line mqm utilities or from your workstation using MQJExplorer/mqmon? I would confirm from there first before worrying that the error is in DS.

Does this scheduled job fail every time? Perhaps it isn't network or time related, but that this schedule starts under a different userid with less authorizations?

If you make the column definitions in your job longer, does the missing data show up?

Since "sockets" are network related I would look there first. Are the sources or targets on a network (NFS-Mount, remote databases, etc.)? What UNIX are you using - you can try to get the ReadSocket() call description to find out what error 16 means.

I haven't gotten that functionality to work with the MQ Connector; I think it requires not only local queues but a local server as well. I have found the freeware product "MQJexplorer" to work sufficiently well, and is preferable to the IBM mqmon.

These are mnemonics for Text Mark (@TM), Field Mark (@FM) and Value Mark (@VM). The latter 2 are used commonly in Pick-type databases. DataStage Server and the other Pick-type databases store records as long strings, often called dynamic arrays, and the field mark (char(254)) is used to separate the...

I think that interpreting "123AA" as an integer is incorrect as well. There are options, though. You can edit the attributes and specify a "In_format" (I can't check now, but "nnnnn" should do the trick). Another alternative is to read these in as CHAR and then using IsValid() or other functions in ...

will return true if it is a valid int32, otherwise it will return false.

I am trying to connect from an AIX box to a DB2 instance on a remote AIX box. I can successfully connect from the command line using "db2 connect to WCCINST1 using ...". I've added and modified the $DSHOME/.odbc.ini entry for WCCINST1 and also changed the "uvodbc.config" file to add this entry. From...

Yes, the tool is the same; PX is a superset of what the Server edition can do.