DSXchange

Hi All,

Additional Information on this issue is, Inside the servershared container , the transformer stage uses a routine to handle some characters.

Thanks
G.K.K

HI All, The parallel job has the UNIDATA Database Stage called through server shared container and it failed with the below error. Can any one please help me in resolving this issue and making me understanding this issue. Thanks! Error: SharedContainer():ds_udtGetNextPacket error calling DSHELPER su...

Thanks Ray for your reply... Now I am facing for two parallel jobs using the UNIDATA DB in the server container with the below errors. Can you please let me know the reason behind this warning and how to resolve these. 1. Invalid character(s) ([xBD]) found converting string (code point(s): from code...

Hi All, I am using the UNIDATA DB in the server container and it is called in the parllel job in 7.5. When I import this job with servercontainer in 9.1 then it is thowing below warning even after setting the UNIDATA DB stage NLS tab to NONE. Can some please help us in resolving this. Warning: Inval...

What ever the parameter or parameterset provided to the db stage, it is thowing the error that i pasted in the above replies. but other stages like dataset stage passing parameters or parameterset is working and substituting proper values

Please find the job log below for the parameter(#DATABASE.SERVER_NAME#) that was unable to substitute value.please check the Event ID=56 : Item #: 46 Event ID: 45 Timestamp:: 2013-06-24 12:04:31 Type: Control User Name: TRY-CC1F48C4|TRY Message:: Starting Job pj_Db2_Read. DATABASE = DATABASE DATABAS...

ray.wurlod wrote:Too many DBs in "=#PS_DB_CONN.DB_DB_PSWD#". ...

It was typo error here. But actual parameter in the job is for the parmeterset is DB_PSWD

chulett wrote:For completeness, can you tell us what the exact version you are running?

I am using Version 8.0.1.

yes.. provide scenarios if u have any special cases

Use NullFieldValue='' under field properties in formattab of sequential file stage.

Thanks
G.K.K

Hi, I have a parallel job with below PARAMETERSET . >Parameterset name :PS_DB_CONN Parameters in the above paramterset are: 1. DB_DSN 2. DB_USERID 3. DB_PSWD >DATASET_PATH=C:/USR/datasets/ I have below job design with the above parameter set and job parameter: DB2 API Stage ---->Targetdataset For th...

Hi, I want to use select query in the parameter where dabasename and schema name is again a parameter . In some of the select queries we have join on multiple tables and other select queries we don't have join . So, if join on multiple tables is part of a select query then how to use it in parameter...

Thanks for the input , the design worked.

Hi All, We are using 8.5 version of datastage. We have 3 columns (Key_Column, Column1, Column2) in the Before and After link of the Change Capture stage. The properties are set as below, Change key : Key_Column Change Values: Column1 & Column2 Change Mode: Explicit Keys and Values When we run th...

Hi, We are developing a generic job with change capture functionality incorporated using a generic stage since the number of change values keep varying at runtime and these change_value columns are to be passed as a single parameter seperated by commas. How to specify the option name and option valu...