DSXchange

Dear All, I have one field(Interest_Rate) in my ardent which is a decimal value.But when i am writing into a file i require that number as S9(10)V9(8) format (COBOL format ie Sign in Front)... For example if THE Interest_Rate is say '4.5678' then it should be formatted as '000000000456780000' . Plea...

Dear Kim & Ray,

Thanks a lot for your help...Exactly the Code is very much useful...i used it in my program....Thanks a lot...Have a nice weekend...

Thanks & Regards,
K.S.Rajan.

Hi All, I am Opening a text file("Rates.txt") using the openseq to and we had Error handling routine also like On Error etc etc... and closing the file can be handled by Close Pollfilename = "D:RatesfilesRates.txt" eg Openseq pollfilename to pollfilevar If i able to open the file...

Dear All, I have a job in which i am taking the source file and writing the same to different text files depends on one field length(basically spiliting the records based on one field total length. The Job is running file and producing the output without any problems but i m getting the following er...

Hi All, I have one sequencer Job say (USADailyControl) Which is calling USA Daily Downloads(1-10),I have another Sequencer Job(CanadaDailyControl) which calls Canada Daily Downloads job(1-7).Now both are independent jobs and running fine.But Now the business needs (want) to call CanadaDailyControl S...

Dear All, I have a Job called (LOADLRRPoolOpics).We are running that job using DataStage Director assume(Job ---> Run Now Option)...I know that we can schedule this job using Menu Opt(Job ---> Add to Schedule). But I want to do that Programmatically(DS Programmint),Ray could you please help me on th...

Dear All, We have Logs for Each job we are running right.We are running jobs using DataStage Director assume...Then we can see those Logs in DataStage Director View---> Logs Option.We can clear the Job logs in DataStage Director using Job ---> Clear Log Option.But I want to Clear those Logs Programm...

Dear Ray,

Thanks for your Timely Help.The Int(Value+0.5) worked well sir.

Thanks & Regars,
K.S.Rajan.

Dear All, In my project I am Subtracting 2 dates.I have ValueDate and MaturityDate So I m doing MaturityDate - ValueDate So that i will get difference in Days.My Business Requirement needs the difference in Months So what i did approxiately (MDATE - VDATE) / 30 So i m getting Difference in Months.Bu...

Dear All, I am having 1 Control job which interns calling 10 Jobs.When i m running the Control Job(Running using DataStage Director) I want to set the Parameter in the Limits(Tab)-->Warnings to 'No limits'(Option) but it is only applicable to the Control Job If I am not wrong.But I want this option ...

Hi Ray, As u told I am getting the following Warning/Info message after Re-setting the Job. Warning/Info Message -------------------- DataStage Job 645 Phantom 84 Program "JOB.1628820055.DT.1297519047.TRANS7": Line 522, Exception raised in GCI subroutine: Access violation. Attempting to Cl...

Dear Ray,

Job is resetting Properly.I am not getting any Info/Warnings messages for that Ray.

Thanks & Regards,
K.S.Rajan.

Dear Ray, Thanks for your suggestions. Here after I will explain the Problem in detail Sir. 1) I did reset the job still the Job failing with the error message "Abnormal termination of stage LoadStagingDLDTSeqToStarWithEnrichment..Map detected" 2) after that i attempted the Try copying the...

Dear Ray, Thanks for your suggestions. Here after I will explain the Problem in detail Sir. 1) I did reset the job still the Job failing with the error message "Abnormal termination of stage LoadStagingDLDTSeqToStarWithEnrichment..Map detected" 2) after that i attempted the Try copying the...

Hi All, When I am running Staging area Job I am getting the Following error. Abnormal termination of stage LoadStagingDLDTSeqToStarWithEnrichment..Map detected If I am running this Job(LoadStagingDLDTSeqToStarWithEnrichment) alone it is working fine if i m calling from Control Job it says this error...