DSXchange

"Connection reset by peer" indicates that you are (were at the time) having network issues. You need to resolve these.

In the Administrator is probably the best place, because the setting is then global for the entire project. (But must be set in each project separately.) You could consider setting the environment variable in every DataStage user process's profile, perhaps via their logon script. If necessary you ca...

The login dialogs are different in version 8. They include a "domain" field that you use to connect to the services tier (WebSphere Application Server) for authentication. The "projects" field is populated with a list of server/project pairs because the one services tier can mana...

No idea until you explain what you mean by "tokens" and "address". If I may guess that you mean "how many tokens exist in the address field" then, yes, a Word investigation using an address rule set will yield patterns. The number of characters in the pattern is the num...

DateFromDaysSince() applied to TimestampToDate() then rebuild the timestamp with the time component from the original timestamp.

And what was the result of DSAttachJob() ? (The best way to check is with some innocuous function like DSGetJobInfo(JobHandle, DSJ.JOBNAME) and log the value of the result. If this returns DSJE.BADHANDLE then your attach failed.)

Any negative number returned from a DataStage API function indicates an error. The error codes are documented in JOBCONTROL.H header file in DSINCLUDE. You can probably search DSXchange to find them. Without seeing your job design it's difficult to comment further. What are you using for the job han...

There isn't one out of the box.

If you've determined the structure of the XMETA database you could possibly run a query against that, but I'm not even sure that sessions are stored there - I suspect they're stored in the metadata server's memory.

... unless the data in the field are:
fixed-width undelimited format
buried in free-form text
gibberish*


* this does not mean "from Gibraltar"

Ensuring no-one is using either project, copy the SDKSequences and D_SDKSequences files from one project (DEV) to the other (UAT). Then, in the UAT project, use the dssh command SETFILE to establish a VOC pointer to SDKSequences.

Start by disabling operator combination, so that you can determine exactly which stage is throwing the error.

More information is required about how these multiple values are stored in their single field. Without that, no cogent reply can be given - different techniques are available to handle different layouts.

I still prefer to use the Left() function, for reasons already stated.

Why not use a Relational Database stage in a mainframe job?

Or Left(DSLink149.INTFC_FILE_CATG, 4) which is beautifully self-documenting.