DSXchange

Blue = link. Hover over it to see the URL and, as noted, click to fast travel there.

(sorry, too much Fallout3 lately)

vintipa wrote:actually i have no idea of the commands like ipcs -mop and ipcrm -m <shmid>. yet to explore these commands.

And yet you have the root password? Oy.

YES. Both of us have stated more than once you do one or the other. Best to properly configure the CFF stage as it can do it all for you automagically. Or use the functions to convert all of the fields, not just the packed ones.

There's pleny of light here. You need to use the CFF stage OR the functions, I get the impression you are doing both. Are you?

You killed what processes as root? And then did what to stop DataStage?

Probably not so much a permissions problem as a 32bit v. 64bit issue, as the latter is not supported AFAIK.

Type s-y-n-c (without the dashes) and press enter. Twice.

Wow, I haven't heard that advice in years.

psssttt... it takes up 2.

Again, if we're still just talking about packed decimal fields, they're neither EBCDIC nor ASCII. Tell us exactly how you tried to use the DataTypePicComp SDK routine and how it didn't work for you, i.e. what came out the other end. Stages, data types and sizes, derivations. Examples are always good...

Looks that way. Like I said, this works just fine in OCI and I don't have DB2 to test it. Best to open a case with your support provider if no-one else chimes in on this.

Try it without the semicolon on the end.

It just needs to be valid sql. I haven't had any problems doing this in the OCI stage but don't have DB2. Are you sure your SQL is valid? Care to post it?

Put the full pathame to the file in the User-Defined SQL area without any {File} qualifier and you should be fine. Note that "file" SQL cannot have job parameter references in it, however.

You should be able to find them all if you search for 'Ascential' in regedit, from what I recall. Pre-8.x anyway.

No clue. What operating system and patch / service pack level is your PC?