DSXchange

Hi , I am facing an issue when reading a data file through a Complex flat file stage. My File naming convention is : csna.src.fmdate.00.dy.TSK001A1.12101213.dat is the file which i am able to read using CFF stage. When i try to read the same file by giving :- csna.src.fmdate.00.dy.TSK001A1.*.dat i a...

The issue has been resolved .

When reading the parameter set , read the parameter with DATE datatype .
The DB2 connector stage recognises the DATE and converts it into its internal format .

Thanks & Regards
Adith

Hi , I Have been facing an issue when i use the DB2 Connector stage . I have defined a user defined SQL Query which joins 4 tables each having approximately 1 million records . Without partitioning , the query executed for a hour. When i checked a few options to implenment parallelism in my Data sta...

Hi Craig ,

I got this error message .

No Authorised routine named "DATE" of type "FUNCTION" having compatible arguments was found SQLSTATE 42884.

The Command in DB2 Connect stage :

where B.OPEN_DT = DATE('#ps_FM_DT.p_FM_DT#' ,'MM/DD/YYYY')

Hi All , I am using a parameter value File(eg: IN_Date in the format YYYY-MM-DD) to be compared with a date column in DB2 . I am using the DB2 connector stage to achive this . However, the job aborts giving an Formating error Please find the representaion in the example in DB2 Connector Stage Eg: Ta...

Thanks Arndw

Thanks Arndw

Hi All , I need some information about where i would get a whole list of Datastage PX Warning message ID's . Belwo is an example With the Message ID . Message ID : TOIX000018 Message Type : Warning Example of Message Txt : Import unsuccessful at record .( This is a generic message ). Regards Francis...

This is a command line input in DS Adminstrator .
SELECT * FROM DS_ROUTINES WHERE NAME ='ROUTINE NAME' ;

regards
Francis Adith

Hi, i am trying to insert data into the DB2 table using the DB2 Load Utility. The source data is coming from a flat file which is of fixed width say for eg.1102ATBRKY0203. In the 10th position we have a character 'Y'. Now using DB2 load utility,i have to load it into the table only if the 10th posit...

Hi , I am getting below error... while loading Data through Db2 bulk load. Test2_DB2UDB_EMP_Job..DB2_UDB_EMP: SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load or load query. Reason code: "1". Path: "Test2_DB2UDB_EMP_Job..DB2_UDB_EMP: SQL3508N Error ...

Hi , I encountered another problem while running the job . Error message : Internal Error: Function 'get_stage_prop' failed Property 'Remote Message File Name' value not found For the property field Remote message file name : *If i mention a path on the DB2 server* will it require details such as us...

Hi , I encountered another problem while running the job . Error message : Internal Error: Function 'get_stage_prop' failed Property 'Remote Message File Name' value not found For the property field Remote message file name : *If i mention a path on the DB2 server* will it require details such as us...

Hi, I had mentioned the path of the source file and the file name from where data has to be Loaded. DB2 UDB Properties: Directory for data and command files : \edw\corp\stg\landing\BMD_SALES.txt Eg : Path :\edw\corp\stg\landing\ * Path where the file is located* File name : BMD_SALES.txt * Source Fi...

Hi , I am using the DB2 UDB Load stage to load data from a Sequential file to DB2 database using DB2 UDB Bulk Load .I have given the Source file name in the DB2 stage against'Directory for Data and Command Files' Error Message : Internal Error: Function 'get_stage_prop' failed Property 'Directory fo...