DSXchange

Rohit Can u please tell me how to create the log file other than what Director maintains??

Hi, I want to archive my Logs Automaticaly in some directory. As far as i know,we have two options to maintain Logs : (1) Auto purge logs over SOME Days.So it will maintain the Log files for job run upto those many runs and after that duration the logs will be purged. (2) Take a print of the logs an...

Master Sequence Design : Job1 -> Routine1 -> StartLoop -> Job2 -> EndLoop Routine1(GetLoopNumber) will calculate a number which will be used as the value for 'To Value' in the StartLoop Activity. StartLoop Properties : Loop Type : Numeric Loop Defination : From : 1 Step : 1 To : Return value of the...

Hi. I have a Master Sequence in which i am using Start Loop and End Loop. As a Sequence property,I have set ' Automatic handle of Job failure' option. Now when I Restart Master Sequence after failure,I am experiencing the following error message : Master_Sequence..JobControl (@StartLoop): Controller...

Hello friends, What we should do..if the process fails/abort before finishing completely. I am not handling exceptions anywhere and also not using terminators. What is the significance of checking the 'RESTARTABLE' check box ticked for a Job sequence. I have all the Job sequences in my master sequen...

Hello,
I am creating sequential files at the output end.And these files have to be transffered to mainframes using Connect Direct.
Please share ur ideas ...on..how to go about this..??

Thanx
Arun

Hi,
I am creating some text files at the output of my job sequence.
These files i have to FTP to Mainframes.File size will be around 1GB
how i can acheive this...??Is there any special settings while sending files to Mainframes...in FTP stage??

Thanx...
Arun

Hi satish, I have 40 sources giving 40 files.Each day each source will produce one file.So 40 files a day.Yes we are also planning to proceed in the same manner which u suggests..but i donot find how to read the sequential file in this manner.Like to find out the row which has it's status as ready.H...

My Job is doing some processing on the input file provided by 40 sources. I have to run my Job as soon as any of the files from these sources comes.the files can be arrived anytime,even when the processing of the previous is not being completed. What we discussed is that we would maintain a sequenti...

Can a stage variable degrade the performance of a Job? Actually i was using 'DSJobStartTimeStamp' DS Macro in 4 column derivation of my job.So i thought of using the StageVariable 'CurrentTimeStamp' in place of those assignments.And equate the 'CurrentTimeStamp' stage variable to 'DSJobStartTimeStam...

actually..i want all the 50 non key values from the hashed file....to be populated for some other table... yesterday..i changed the meta data and the problem get resolved but...this doesnot work today...that's why i m asking again.. :-) PP_GL_JRNL_LN_v9..GLJournalLineProcessingV1C17.GL_Journal_Line_...

Hello friends, I am experiencing some warning messages while writing into the Hashed file.My hashed file has more than 5 keys and the 50 non key fields. Error message : PP_GL_JRNL_LN_v9..GLJournalLineProcessingV1C17.GL_Journal_Line_Hashed.Link_To_GL_Journal_Lines_Hash: ds_uvput() - Write failed for ...

Hello friends, i m experiencing some problem while running my job. Sometimes it get aborted due to this error message : PP_GL_JRNL_LN_v6..GLJournalLineProcessingV1C17.Account_Descr.Account_Descr_ToHash: WriteHash() - Write failed for record id 'FEDRL 5010 -24835' This error is not frequent. I am cre...

Hi DSGuru,
I m working on DB2 on mainframes...would i be able to use DB2 Bulk load utility in that case also??

Ok...
Thanx Hulett!!!