DSXchange

I understand Mike. My issue in fact is that my database at the end is Varchar(10 bytes). and cause me trouble.

Thank you very much mike

Well, shared container must be seen like a simple DataStage job. The shared container just permit to factorize process that will be use in multiple jobs. Said in another words, shared container can't do more than a job can do. You can't use a shared container to make a process than you can't do i a ...

- Exports jobs in a dsx
- Take a coffee
- Then go for load stage and options in the dsx

such process exist, but it was proprietary code. You can export dsx and analyze it, you can import it in a database or whatever. There is full of possibilities. Just do it or find it.

It's funny, another guy asked for the same logic yesterday.
viewtopic.php?t=151504

in a transformer, use
(@PARTITIONNUM*2+1) + ((@NUMPARTITIONS*2)*(@INROWNUM-1))

Interesting, but this guy want to transfer a dataset from prod to dev.

Dataset shouldn't be read in another environment and you can't easily do that. You should read directly in production if you have access. Anyway, I don't know the reason why you want to see production data, but if you want to debug a job, you should create a set of data in dev independently of produ...

you are missing information, you should create a surrogate key in the before file based on the line number it will be your key but in your exemple, why do you say "record 4, col1, delete" I see it as an update record 4 before 1,1,1 after 5,2,2 the output could be record 4, col1, update rec...

Well, you can make it. but be careful, my suggestion contains a Cartesian product, so if the volume is too big, you will explode your time execution. I will use your example in my demonstration. You take all the field Fld_1 and make a remove duplicate, and add a join key you will have: 11111;1 22222...

It should,
Develop step by step.
First step : validate your schema file without rcp, make sure that you read your file correctly.
You can use import table definition and see the layout parallel generated.
Then, make your job with rcp, it should work.

so the vertical pivot stage is the stage you need. But, in your exemple you have "genarate" 4 information ST_ID XY_ID ZX_ID YZ_ID ------------------------------------------------------------ 1 100 (input) 200 (input) 400 (input) 1 100 (gener.) 200 (gener.) 300 (input) 1 100 (gener.) 200 (g...

Well, I think the quickest way and the easier way is to use a awk command you create your file with all data. And after that run a awk command reading all lines and writing them in output files. the output files name contains a parameter witch is the value of the id_session of the line. something li...

First of all, you have to consider the number of distinct occurrences in CT_YS column. If this number is variable or unlimited, you want an output with variable or unlimited columns, which is not possible in a vertical pivot stage . You can only use vertical pivot stage if the number of occurrence i...

Waiting the end point to check that a column have the good format is in my opinion not a good thing to do. Using the isvalid function may involve a lot of coding. In your case, I'll check when reading the source with a column import and reject lines with wrong format if your source is a file. If you...