Hi all,
input is a file in which it has an update indicators I --insert
U-update
D-delete
so target is table , and i have a transformer in which i have
following constraints
Trim(insandupdtrec.Updt_ind) = 'U'
Trim(insandupdtrec.Updt_ind) = 'I'
Trim(insandupdtrec.Updt_ind) = 'D'
and for the target table transaction handling accordingly choosen
and sql is generated one for type of transaction code
i donot nothing is coming out of the out links , for now i have records
that have update indicator as "I"
no errors
no warnings
just datasource is empty
i tried with target as sequential file instead of table then filtering is done
accordingly.
could some one please explain me where iam missing,
thank you all,
Ora Oci 8 not loading to the table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Did you check the job log for reject messages? Did you add a reject link to collect DB rejects?
If the same exact link with constraint can write to a sequential text file, then the only issue is the database. What do the link statistics show for the job?
If the same exact link with constraint can write to a sequential text file, then the only issue is the database. What do the link statistics show for the job?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Thank you very much Ken,
i created a reject file and every row is rejected for the following error
BUSINESSATTCOMLOADTBLE..fmtrec: The value of the row is: ATT_COM_ID = 26587 LKEY_ID = 15621079 COMPANY_NM = JARIT SURGICAL INSTRUMENTS ADDR_LINE1 = NULL ADDR_LINE2 = NULL CITY = NULL STATE = NULL STATE_CD = NULL COUNTRY = NEW YORK POSTAL_CODE = UNITED STATES ZIP_CD = UNITE ZIP_EXT_CD = CONTACT_FIRST_NM = RICHARD CONTACT_MIDDLE_INIT = NULL CONTACT_LAST_NM = CONLEY CONTACT_TITLE = IT/IS DIRECTOR PHONE_TEXT = NULL PHONE = NULL EMAIL_ADDRESS = rconley@jarit.com ROLE = NULL ANNUAL_REV = NULL INDUSTRY = MEDICAL PRIMARY_SOLUTION =
could some one please help me ,
i checked the date for is fine
the following are the derivations used in the date fields
if (IsNull(insandupdtrec.Last_Activity_Date)) Then @NULL Else Oconv((Iconv(insandupdtrec.Last_Activity_Date,"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]")
2nd one
Oconv(Date() , "D4/MDY")
thank you all
i created a reject file and every row is rejected for the following error
BUSINESSATTCOMLOADTBLE..fmtrec: The value of the row is: ATT_COM_ID = 26587 LKEY_ID = 15621079 COMPANY_NM = JARIT SURGICAL INSTRUMENTS ADDR_LINE1 = NULL ADDR_LINE2 = NULL CITY = NULL STATE = NULL STATE_CD = NULL COUNTRY = NEW YORK POSTAL_CODE = UNITED STATES ZIP_CD = UNITE ZIP_EXT_CD = CONTACT_FIRST_NM = RICHARD CONTACT_MIDDLE_INIT = NULL CONTACT_LAST_NM = CONLEY CONTACT_TITLE = IT/IS DIRECTOR PHONE_TEXT = NULL PHONE = NULL EMAIL_ADDRESS = rconley@jarit.com ROLE = NULL ANNUAL_REV = NULL INDUSTRY = MEDICAL PRIMARY_SOLUTION =
Code: Select all
BUSINESSATTCOMLOADTBLE..fmtrec: ORA-01843: not a valid month
i checked the date for is fine
the following are the derivations used in the date fields
if (IsNull(insandupdtrec.Last_Activity_Date)) Then @NULL Else Oconv((Iconv(insandupdtrec.Last_Activity_Date,"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]")
2nd one
Oconv(Date() , "D4/MDY")
thank you all
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Thank you very much Ken,
i created a reject file and every row is rejected for the following error
BUSINESSATTCOMLOADTBLE..fmtrec: The value of the row is: ATT_COM_ID = 26587 LKEY_ID = 15621079 COMPANY_NM = JARIT SURGICAL INSTRUMENTS ADDR_LINE1 = NULL ADDR_LINE2 = NULL CITY = NULL STATE = NULL STATE_CD = NULL COUNTRY = NEW YORK POSTAL_CODE = UNITED STATES ZIP_CD = UNITE ZIP_EXT_CD = CONTACT_FIRST_NM = RICHARD CONTACT_MIDDLE_INIT = NULL CONTACT_LAST_NM = CONLEY CONTACT_TITLE = IT/IS DIRECTOR PHONE_TEXT = NULL PHONE = NULL EMAIL_ADDRESS = rconley@jarit.com ROLE = NULL ANNUAL_REV = NULL INDUSTRY = MEDICAL PRIMARY_SOLUTION =
could some one please help me ,
i checked the date for is fine
the following are the derivations used in the date fields
if (IsNull(insandupdtrec.Last_Activity_Date)) Then @NULL Else Oconv((Iconv(insandupdtrec.Last_Activity_Date,"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]")
2nd one
Oconv(Date() , "D4/MDY")
thank you all
i created a reject file and every row is rejected for the following error
BUSINESSATTCOMLOADTBLE..fmtrec: The value of the row is: ATT_COM_ID = 26587 LKEY_ID = 15621079 COMPANY_NM = JARIT SURGICAL INSTRUMENTS ADDR_LINE1 = NULL ADDR_LINE2 = NULL CITY = NULL STATE = NULL STATE_CD = NULL COUNTRY = NEW YORK POSTAL_CODE = UNITED STATES ZIP_CD = UNITE ZIP_EXT_CD = CONTACT_FIRST_NM = RICHARD CONTACT_MIDDLE_INIT = NULL CONTACT_LAST_NM = CONLEY CONTACT_TITLE = IT/IS DIRECTOR PHONE_TEXT = NULL PHONE = NULL EMAIL_ADDRESS = rconley@jarit.com ROLE = NULL ANNUAL_REV = NULL INDUSTRY = MEDICAL PRIMARY_SOLUTION =
Code: Select all
BUSINESSATTCOMLOADTBLE..fmtrec: ORA-01843: not a valid month
i checked the date for is fine
the following are the derivations used in the date fields
if (IsNull(insandupdtrec.Last_Activity_Date)) Then @NULL Else Oconv((Iconv(insandupdtrec.Last_Activity_Date,"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]")
2nd one
Oconv(Date() , "D4/MDY")
thank you all
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're lucky it's after the 9th of the month and after September, so you're automatically getting two-digits in the month and day. You need to force two digits as follows:
Code: Select all
Oconv(Date(), "D-YMD[4,2,2]") : " 00:00:00"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.