DSXchange

Hi All, while running a sequence in UAT environment i got it aborted and the message in log is: 16:28:19: Exception raised: @IBTLoan_Update_Chkpnt_Complete_Job, Error calling DSRunJob (IBTLoan_Update_Chkpnt_Complet e_Job.IBT), code=-14 [Timed out while waiting for an event] and log for the job IBTLo...

Error Message

main_program: Error parsing modify adapter: Error in binding: Error in destination field selector: Expected integer, got: ":"
Expected destination field selector, got: ")"; input:
IBT_MAT_DT[:DATE] = date_from_string [%mm/%dd/%yyyy] (MATDT)
;

Hi, I am using this code in Modify stage. IBT_MAT_DT:DATE = date_from_string [%mm/%dd/%yyyy] MATDT IBT_MAT_DT->new column name DATE ->new type date_from_string [%mm/%dd/%yyyy] -> new format MATDT -> Old column name am getting error. let me know the correct format and how to handle null values here. ...

Hi, I am using this code in Modify stage. IBT_MAT_DT:DATE = date_from_string [%mm/%dd/%yyyy] MATDT IBT_MAT_DT->new column name DATE ->new type date_from_string [%mm/%dd/%yyyy] -> new format MATDT -> Old column name am getting error. let me know the correct format and how to handle null values here. ...

Hi, I am using this function to handle null values in date conversion from string to date. If IsNull(Caldt) then handle_null(Caldt, StringToDate("12/31/9999","%mm/%dd/%yyyy") else StringToDate(Caldt,"%mm/%dd/%yyyy") I am getting it in red color. what is modify stage? Le...

Hi,

Is handle_null is a function is datastage?
it is not accepting

thx,
deepak

Hi DsGuru,

For non null values i will use conversion function for null values how to handle them as datatype in target is date
how to pass null values there.

thx,
deepak

Hi, I have a requirement where i need to convert varchar to date. I am using the conversion function stringtodate as below StringToDate(Caldt,"%mm/%dd/%yyyy") output date format should be mm/dd/yyyy data is loading successfully but still am getting warnings like "APT_CombinedOperatorC...

Hi Ray,
thx for the reply.
but am able to run it for soem 1000 records, getting this problem only when i tried run with whole file which has around 25k records.

regards,
Deepak

Hi All, I got an error while loading data to table. below am copying the error from the log Stage_IBTLoan,1: Open failed for update: update is: INSERT INTO STAGE_IBT_LOAN (IBT_LOAN_SQ,CALENDAR_DT, IBT_CTPY_ID, IBT_POS_TYPE_CD, IBT_ISSUE_CTRY_CD, IBT_TRADE_CTRY_CD, IBT_MAT_DT, IBT_COLL_CCY_ID, IBT_SE...

Hi Anil, Cal Dt : 09/04/2007 (around 20k record woth same date) val Dt: 09/04/2007 (1 record) Deepak, Can you give some example. Left_Key_val Calender_dt Right_Key_val2 valuedate 1 10/09/2007 1 10/09/2007 2 10/08/2007 2 10/07/2007 What is the output you need ? Do you want Inner join , Left Outer or ...

Hi Anil, thx for the reply. data is same for both the columns its in mm/dd/yyyy format. thx, Deepak Deepak, Can you please give the Date values for the source and also how should be value in Target. Please give the Data Types for the Calendar_dt and Value Dt. Do you want to Concat both the date valu...

Hi. i have some issues in date conversions. i have a input file .dat which has a column calendar dt and a .txt file which has a column valuedate. i have to join these 2 column to load the data into table. i have used stringtodate conversion for valuedate and kept the calendar dt as it is. both shoul...

Hi Ray,

There was no ^J character in the file. if i run the job alone its running successfully without any warnings. but in only sequence am getting warnings.

Hi All, I have a job where am trying to extract data from a text file, which is in unix. i have set the format as below final delimeter-end record delimeter- UNIX newline delimeter- comma quote- double the job alone is working fine. later i created a sequence with the above job and called an invocat...