DSXchange

Welcome aboard. Chances are that users have not been set up or credentialled in Information Server (or at least the user ID that you are trying to use). You need to open the Web Console for Information Server and log in there as an Information Server Administrator (probably a user ID of isadmin) to ...

It's the fix_zero argument to the conversion functions.

Parallel Job Developer's Guide p628 wrote:By default decimal numbers comprising all zeroes are treated as invalid. If the string fix_zero is specified as a second argument, then all zero decimal values are regarded as valid.

It's not.

ray.wurlod wrote:But this reinstates the situation to which devhni was objecting.

I was pointing out that "=" won't answer the question either.

Use a Complex Flat File stage, which knows how to deal with them.

Get the COBOL copybook (FD) associated with the data, import that as a table definition, and load that into the Complex Flat File stage so that your metadata reflect what's there.

It's all Oracle bin Larry's fault for not having a proper Integer data type. You can not prevent this message without adjusting your metadata precisely to match that of Oracle, and even then you will get a message logged (a slightly different one). This is one of those alert messages that it is safe...

Don't forget to create DSN entries in uvodbc.config file in the project.

I wonder whether it's still very urgent three months on?

Prefer DateFromDaysSince() function.

Presumably, then, the change(s) that you wrought is where you should be seeking a culprit. Since you chose not to reveal what "some changes" involves, your question is in the class "my car won't start", and we prefer not to waste too much time guessing. Tell us what you did and t...

Don't know. Try it. There is, of course, a risk once the sequence values become too large to be represented as Integer. On that basis I would suggest that the other applications will need to be changed. That said, since you are creating this sequence, they presumably don't work already.

Welcome aboard. What execution mode are you using for the Aggregator stage? What aggregation mode (sort or hash) are you using?

If you are running version 8.1 or later the DB2 Connector can connect to different platforms.

The invocation ID can be a reference to a parameter from the controlling sequence.

can u give some example how to set and wt i need to set in PATH and other two environment variable also so that i can understood how to set based on my folder stucture. please help me out Not "u", but "you". U is one of our posters. Not "wt", but "what". Ordi...

Why not just use the link variables DBMSCODE and LASTERR (which contain the code and the text respectively)?