DSXchange

As said ArndW, you can simply convert EBCDIC to ASCII / ASCII to EBCDIC with either Sequential Stage or Column Import / Export Stage. In the Sequential Stage, go to Output, Format, in Type Default \ General, set Character Set = EBCDIC and Data Format = Binary. Now for each columns, the best is to se...

There's a sequence (key) generator in 7x but there's nothing in 6x in fact. The only way i see in 6x for a unique sequence is either use "SEQ.NEXT_VAL"... either use in transformer something like : (@INROWNUM * @NUMPARTITIONS) + @PARTITIONNUM as a sequence but don't remember if in 6x u can...

in fact u need to rename ur column, u must have the same name for the key.

rename ur "col5" in "col2", and it'll work.
u can rename the column with several stages... sometimes the most simple is to use a "Copy" to rename.

Hi, got a problem with the Oracle stage, when i use Sql Loader. I have some datas that can have one blank (ie: CD_TEST varchar (10) not nullable = ' ') The problem is that the loader don't use delimiters by default, it's fix lenght, and with the ctl generated, blanks means NULL. So when i load datas...