DSXchange

Hi

What will be the return value of the dscmdexport command, when it fails to export the project ?


D:\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=PROJ01W /U=vazarvv /P=t1234 TEST_PROJECT d:\temp\vivek.dsx

WoMaWil wrote:what do you have as input and how does it look like?

Hi Thanks for your replay ?

Source is the .txt file having 5 columns and target is having 6 columns.

There is a difference of 1 columns n that column I want to populate with current date with time stamp.

Hi All,

Please let me know how to generate the Time stamp value in the transformer stage in the 2008-09-24 03:35:55 format.


Thanks,
Vivek

Hi All, My source file .txt having a date value and I'm trying to load it into the Teradata database. The teradata database having DATE column. In the transform the datastage job gets abort with error. Job_10_TD_SBT_Load..Transform: At row 1, link "ToLoad", while processing column "Sc...

Hi,

I'm using DB2 API stage for data extraction. It showing following error.

Job_DB2_ERDBP01_Login..DB2: [IBM][CLI Driver] SQL1013N The database alias name or database name "ERDBP01" could not be found. SQLSTATE=42705

DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'erdbp01'.

Show us how these "variables" (which look suspiciously like input column references) "point to" environment variables. ... Thanks.. The content of the variable is the name of the Environment variable. Here I'm just trying to implement Pointer to Pointer C++ concept. If you have ...

Can you get it to work using regular job parameters? Take the parameters file out of the picture for a moment, for the purposes of diagnosis. Second, ought you not to be passing the environment va ... The following command working fine. If DSLink9.JOBTYPE= 'TD' Then UtilityRunJob("Teradata_Log...

The error in log is DelPendConsUsg..DCX_PENDING_CONSOLIDATED_USAGE: DELETE FROM DCX_PENDING_CONSOLIDATED_USAGE WHERE OBJ_ID = :1 DelPendConsUsg..S_ROT_CLASS: DELETE FROM S_ROT_CLASS WHERE OBJ_ID = :1 DelPendConsUsg..xmfPendDelUsg: The value of the row is: OBJ_ID = DelPendConsUsg..xmfPendDelUsg: ORA...

The error in log is DelPendConsUsg..DCX_PENDING_CONSOLIDATED_USAGE: DELETE FROM DCX_PENDING_CONSOLIDATED_USAGE WHERE OBJ_ID = :1 DelPendConsUsg..S_ROT_CLASS: DELETE FROM S_ROT_CLASS WHERE OBJ_ID = :1 DelPendConsUsg..xmfPendDelUsg: The value of the row is: OBJ_ID = DelPendConsUsg..xmfPendDelUsg: ORA...

Show us precisely the call you are making, and describe where you are making it from. If an expression is involved, did you build this using the keyboard or the expression editor? ... Hi, Thanks for your replay. Below is the scenario. ParamFile---> Transformer---->Staging_File If DSLink9.JOBTYPE= '...

Hi All,

I'm trying to call the the datastage job through UtilityRunJob routine and passing Enviroment variable as a parameter. But the called datastage job doesnot referencing the actual enviroment variable value. The called datastage job considering the enviroment variable as a value.

Set these variable values to "$PROJDEF" in the job. Then you dont have to specify them in dsjob command. Every time the job is run the project level value of the variable is taken. Thanks for your replay. In the next run I want to use $SalesDBUserID, $SalesDBPwd & $DBServer20 with Ter...

What does "not working" mean in this context? What error message is generated? Why are you setting $LegacyDBUserID for each of the three parameters? That's almost certain not to be correct. ... Hi, I made few changes. Now I'm trying to use these Userdefined environment variables with dsjo...

Hi, I want to use userdefined environment variable into the dsjob command. Consider I declared 3 userdefined environment variables into the project ex:- 1) $LegacyDBUserID 2) $LegacyDBPwd 3) $DBServer20. They are having content userid, password and server name respectively. I want pass these 3 userd...

Hi, Try ODBC plugin to extract data from VSAM file. Hello, I am looking for any information on how to extract data from a VSAM file. I could not find any hits on 'VSAM' when I searched the forum. Is anyone out there extracting data from MainFrame VSAM files ? If so, could they please let me know how...