DSXchange

I like the yelling

Which PID would you be interested in. The one that initiates your job? When you run a job, you will see several pid's for that one particular job.

Welcome Aboard
So you have to fire a stored proc. for each row, ouch, thats nasty. If the Id's are running numbers, just get the max from table and start adding @INROWNUM for each row.

And with your code, you need to provide LEN(in.col) - 1 for stage variable LEN1. It will work

Also keep in mind that in server, there is no true datatype, everything is stored and processed as characters. Its the database that encounter problems. This is why an explicity conversion was required.

Use a message handler to demote it as an informational message. I say fix your job. Tomorrow the same warning might become into a fatal error.

Its the Release Notes. Go in there. On the left window pane you will find that "Whats New" option.

I meant the STATUS statement. Opsi daisy, grasshopper at its best huh !!!

You said pass a pointer not pass an array. There is a difference. Arrays are defined as 'char' which is present in your list. Anywho, try what I suggested and see if that works.

chulett wrote:[/i] Load the keys from your source file into a work table and use that to constrain your build sql for the hashed file.

Ahh, now I see. I am going blind...

Ok now your more clear when you said pass arrays as argument. As a stand alone function you can pass arrays as arguments. Like void printArray(char myArr[], int size) I am not sure if you can do this inside datastage. Have you tried specifying char as your input and suffixing your argument w...

Load your file into a temp table and do a sql join. See if that works out for you.

Great, keep us posted.

I am not able to get what do you mean by "eat a pointer". Will you be passing the string or the memory address of the string? You cannot do the latter, how will you get the memory address of the string inside datastage? Pass the values in as arguments. For example if I want to concatenate 3 fields, ...

IBM should be able to tell you that. You should have asked em', "On what occurances can the osh file change"? Does your system admin have any clue?