DSXchange

Hi , My job is running fine in Dev but in qa failed with following error AUDIT_JOB_BATCH,0: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field "JOB_BATCH_GK". My job design is odbc(audit_job_batch) . . seq file...........................lkp..................

hi, i am using the query in ODBC stage but i am getting follwoing error. ODBC_Connector_0: Schema reconciliation detected a size mismatch for column JFCSALE. When reading database column DATETIME(fraction=3) into column DATETIME(fraction=0), truncation, loss of precision or data corruption can occur...

Thanks j wiles for quick resposnse. so according to your suggestion i need to work with DBA to check whether the tables are defined properly in QA database according to DEV or not. Please correct me for follwing example. if i have ACCT_STATUS column is in table in DEV and it should be same in name a...

hi, i have built one job and run fine in dev environment. in job i am using oracle connector stage and using the query in it and tranform the records into seq file but when i migrate to qa i am getting the following error Oracle_stage: When checking operator: The modify operator keeps field "AM...

hi chullet,

Thanks for reply .can you please explain the solution that you have provided and how can i fix this .

Hi all, i am extracting data from fix width file Record delimiter:unix newline reocord lenght:fixed quote:none delimiter:none The following errors iam getting. Bad record delimiter after fixed-length record: expected "\n", got " " seq_Account,0: Short read encountered on import; ...

Hi i am extracting the fixed width and getting followign error sf_file,0: Bad record delimiter after fixed-length record: expected " ", got "0" This i am getting in director but when i view data in file getting Bad record delimiter after fixed-length record: expected "\n&quo...

Hi, i am doing look up on source and refernce and the follwoing error i am getting. lkp_PrinBal,1: Failed a key lookup for record 186 Key Values: FAC_CUST_ID: 00000809 my design is like refrence(seqfile) . seq file . source......................lkp........................seq file I am doing lookup o...

Hi Arnd Select case SUBSTRING(lc.refno,1,3) when 'OSB' THEN SO.AMT WHEN 'OSG' THEN SO.AMT WHEN 'PPS' THEN SO.AMT ELSE LC.AMT END AS CURR_BALANCE From table name can you help me how can i fix this with float because ODBC is expecting the DLFOAT and whenever i give the decimal i got the following erro...

Hi bhasd so both Neg(MonthFromDate(TimestampToDate(update.IssueDate))- MonthFromDate(TimestampToDate(update.ExpiryDate or Neg(DaysSinceFromDate(TimeStampToDate(update.IssueDate),TimeStampToDate(update.ExpiryDate)))/30 Can you please advise on this i can use either one of them giving me the same result

Thanks for providing this solution.I appreciate.This resolves.....

Hi chulett i have check the datatype in table .It is float for amt with Precsion 53 and scale is null and ref no is char the Query i am using Select case SUBSTRING(lc.refno,1,3) when 'OSB' THEN SO.AMT WHEN 'OSG' THEN SO.AMT WHEN 'PPS' THEN SO.AMT ELSE LC.AMT END AS CURR_BALANCE From table name I tri...

Hi chullet,

i know he did for days being very new to datastage can you please provide the whole code .....

Hi Arnd,

Can you provide the code that i can use in transformer to get the number of days and then compute the months

Hi Arnnd

i saw only Float in datatype in ODBC stage how can i use dfloat please let me know about.