DSXchange

I am trying update using user defined query as below.It is not really updating and throwing a warning. UPDATE #MVS_SCHEMA#.exchg_45day_to_55day SET AMT_PAR_AVAIL_45DAY=?, AMT_PAR_EXCHG_55DAY=?, RATE_AVAIL_45DAY=?, RATE_EXCHG_55DAY=?, DT_LST_UPDT=?, ID_USER_LST_UPDT=? WHERE NBR_CUSIP_55DAY=? AND NBR_...

Thanks for your help Craig. All I had to do is to CLEAR. FILE RT_LOG 19 and now I am able to view the log from director.

But the job was running till now and once I cleared the log the job stopped. I had to go back and restart the job.

These are details

Dataset name : F251PB.UNLOAD.DSZ7P000.PSPP(0)
user : s40862

Can somebody look at this.Your help is appreciated

I am getting not a valid remote file error in FTP Enterprise stage when I am trying to read GDG file from mainframe. I am using following URI ftp://#ServerName#/#DSName# These are my details Dataset name F251PB.UNLOAD.DSZ7P000.PSPP(0) user s40862 It is working with command line .Also FTP plugin is w...

I am writing to flat file.It is a write failure and is resolved.I tried to clean data before writing by removing CR+LF etc. The other problem is when I am reading from hash file in another job,getting following message and job aborts. It is giving following error and aborts DataStage Job 76 Phantom ...

Sorry.I might have confused you by mixing two issues here. One is reading hash file and other is with CSV file. The issue with CSV file is resolved.I am gussing there might be non-printable character or CR+LF in source file that caused write failure. I cleansed data before writing to output file and...

Also I am getting following error on and off when am trying to read CSV file and create another CSV in job control. Attempting to Cleanup after ABORT raised in stage JobExtractFileNameValue..JobControl. (SeqChkScrubFiles) <- JobExtractFileNameValue: Job under control finished. I reset the jobs and t...

Thanks guys.I tried using both options but still this problem is coming sometimes.Is there any other reasons for this thing to happen.

Clear file option is on.This error occurs on and off.Some times job runs fine without errors.Do we need change any settings .

I tried resetting and re-run again.There is nothing other than this error message in log.

Thanks Ray. Yes .Hash file is by this name.I will try to reset and see of there is any addl message.

My job is like this below. seq-->xfrm-->xfrm--hashfile It is giving following error and aborts DataStage Job 76 Phantom 5364 Program "DSD.UVOpen": Line 572, Exception raised in GCI subroutine: Integer division by zero. Attempting to Cleanup after ABORT raised in stage JobCreateSrcHdrs..hsh...

[quote="DSguru2B"]yea, you will have to code it. Your routine should be smart enough to handle leap years, and know when to add 30 days and when to add 31 days. Its not easy, i agree, but its dooable. OR if you want the easy way out, load your flat file in a temp table and then use oracle'...

[quote="narsingrp"]I need to add a month to date and do some checks in transformer stage.My source is from flat file.I can write routine to call Oracle and use Add_Months function in oracle but it opens up and closes oracle session for each row when I call routine in transformer stage.Any ...

I need to add a month to date and do some checks in transformer stage.My source is from flat file.I can write routine to call Oracle and use Add_Months function in oracle but it opens up and closes oracle session for each row when I call routine in transformer stage.Any suggestions will be appreciat...