DSXchange

chulett wrote:Assuming the problem is creating it, look into the use of the Trigger Column option, value changes there will trigger a switch to a new output filename. ...

He said there are 8 million records. By enabling this, wont it create as many files?

Or even in a simpler way, create a stage variable like this:

sv1 = sv1 : ',' : InputColumn

and map it to the target column derivation.

The last output row will have all the values...

Can you try with this ( (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1) Thanks Vinoth! But no luck with this as well. When I use this, The sequence number starts with 1 but gives a count of 177. Actual is 175. I will try with some other set of records and let you know. Your count and actual m...

Does your input file have a header record or column headers in the first sequential record? That might be why your maximum row number is greater than the number of data records. That's a guess, because when the documentation says "column header records are ignored during processing" it do...

If your input is sequential file, then you can set Row Number column option in Properties to get the sequential number. I just tried this by keeping a sequential file as a source. But the sequence number starts with 0 for every partition. :( Yes Row number starts with zero. But How do you get diffe...

anbu wrote:If your input is sequential file, then you can set Row Number column option in Properties to get the sequential number.

I just tried this by keeping a sequential file as a source. But the sequence number starts with 0 for every partition.

anbu wrote:If your input is sequential file, then you can set Row Number column option in Properties to get the sequential number.

Thanks Anbu. My source is most of the time is an EBCDIC file or a Dataset.

vinothkumar wrote:Can you try with this

( (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1)

Thanks Vinoth! But no luck with this as well. When I use this, The sequence number starts with 1 but gives a count of 177. Actual is 175. I will try with some other set of records and let you know.

Also, you can check in your job whether there is a space at the end of the file name.

Might be the user ID datastage use is a different one? Check the ID which datastage uses while executing the job. I mean, not the datastage login ID. The Unix user which your DS ID uses inturn.

The best way I know is that, you can create two sep XMLs, one for the office code and another for the Department. In both the XMLs, create a column 'Office Code' in the tabular format ( not as XML). Then again, join both the XMLs using this column. And in your final XML O/P stage, Map only the requi...

Yeah! Possibly be a permission problem.

Hi all, Thank you very much now i am able to call the shellscript. Suppose i need to pass a argument to the DSexecute command from a function i.e. s = Arg1 Call DSExecute('UNIX','sh check.sh s ',Output, SystemReturnCode) But i am not able to pass the actual value. Kindly advice. May be try somethin...

What is your source? Where does your transformer gets the data from? Are you using look-up?

ray.wurlod wrote:Something like

Code: Select all

 Iconv(InLink.TheDecimal, "MD2-") 

should do it. ...

This is great. I never thought it would handle a trailing sign, though I use "MD" a lot. Thanks Ray.