DSXchange

Yes it works but It doesn't fit my needs.

I use local message handler to solve it.

I forgot to mention, yes RCP is activated.

Main idea is to keep these special columns even KEEP specification. (developpers doesn't have to know that kinds of columns exist).

With KEEP spec, the unwanted "Techs_Cols" still exists in output dataset.

I'm afraid that the only solution is to use message handler.

Hi datastage community, I have currently an issue when manipulating record defined as 'intact' when subrecords have "drop" property. Schema: record ( ID_TECH: nullable decimal[4,0]; COL_1:nullable string; COL_2:nullable string; Techs_Cols: record {final_delim=none, delim=",", int...

I've got the same pb recently, it was a conflict with dll called "ExGrid.dll".

In my case.
The software HP Quality Center load his own version of this libray and so DataStage Client use it and show a weird pane.

The job don't compile with this call, the stage transformer doesn't want this. Do i have to add something to call the char function with two arguments?

So i find an workaround for my business case which consist to do the same thing in database when i extract data, directly in the query.

IN which component do you use the job parameter ?
In a stage transformer, row generator, ?

Hi everyone, I've got in a string column a weird character (0x96, 150 in decimal) which cause some trouble, so i try to eliminate this by using Convert function in a stage transformer. I define a derivation like this: final_column=Convert(Char(150),"-",original_column) The result string(fi...

May be is the number warning message allowed before datastage send abort signal no? Try to set old value when your run the job (no limit ?) or try to handle all your not null columns (better solution). A job must be finished with status "finished ok" not "finished ok with warning(s)&q...

RCP is disabled at project level.

I do some test with server job it doesn't work.(DSGetLinkMetaData gives no information with job server).

kandyshandy wrote:encoding & decoding images in DataStage?

+1

Binary of image is included in the xml flow?

Have you try DS.CHECKER command ?

It seems that your different format in your file (fixe format?).

First format use 40 byte and aonther one uses only 27 bytes.

Try to separate different format in import step.

@kandyshandy: My goal is to control the naming convention precisely. ;) I forgot to write that i used the method "listlinktype = DSGetStageInfo (hJob, stagename, DSJ.LINKTYPES)" first. I can only deduce this: linktype value = 1: input stream linktype value = 2: reference stream linktype va...

Hi everyone, I work on a job server (BASIC code) to scan all jobs in a projectto get information about datastage design. For each job i want to know names of stages presents, names of the links, etc.. I'm really close to get all information i want but i have a trouble with link. I don't know how to ...