DSXchange

Sorry, didn't look close enough at your actual code. I don't think you actually have to convert the time at all, I meant just cat it on the end of the converted date. ... Hi Craig, I tried just concatenating the two columns as listed below, DSLink4.LOG_DT : DSLink4.LOG_TM but that caused the follow...

Concatenation with a space between. That plus either IConv/OConv or substring to convert the date to YYYY-MM-DD format. ... Hi Craig, Thank you for your help. I tried the Oconv/Iconv that is listed below, Oconv(Iconv(DSLink4.LOG_DT,"DYMD" ) + Iconv(DSLink4.LOG_TM,"MTHS"),"D...

Hello all, I am trying to convert two columns (log_dt and log_tm) into a date-time column to load into an Oracle table. In the input file, log_dt is defined as varchar ( 10 ) and is in the 'mm/dd/yyyy' format. The log_tm column is defined as varchar ( 8 ) and is in the 'hh:mi:ss' format. Because the...

Yes, cause everything to log a warning in the sequence if the activity does not finish with success status, then intercept and process any warning that is generated. If every sequence is so set, all ... Ray, Thank you for your input. Unfortunately, I can't read your entire answer because I am not a...

All, We have requirement to make our weekly Data Warehouse load fully restartable. At the moment, we have a job sequence that runs 9 server jobs sequentially (J1 through J9). Each server job will in turn run its own sub jobs. The 9 server jobs and their sub jobs consist of a total of 54 server jobs....

chulett wrote:Yes & Yes. The DOS command to delete a file is "del" or "erase". ...

Craig,
Thank you so much. Your input will help our organization a great deal.

Seyed

chulett wrote:In an Execute Command stage do:

echo "Production ran successfully" > YourFilename ...

Craig,
I appreciate your input. Would this create the file and then can this file be deleted at the end of job sequence in our development environment?

Thanks again,

Seyed

kandyshandy wrote:In the body of the email, DS does not substitute parameter with its value.

Hello kandyshandy,
Thank you very much for the information. I won't spend any more time on this issue. I will just hard code the file name in the body of the e-mail.

Continued Success,

Seyed

All, I have put in several e-mail notification activities in a job sequence. They work fine and generate e-mail under certain conditions. However, I have noticed that the e-mail notifications have problems with parameter substitutions. The parameter substitutions work correctly in the subject line o...

From what you are saying, the status in the end was not 'Aborted'. How do I go about fixing the job sequence to have an 'Aborted' status when a job in the sequence aborts? Seyed You will need to select "Automatically Handle activities that fail" with in the Job Properties of the Job seque...

Job Activity #1 Check Pointed Job Activity #2 Check Pointed Job Activity #3 Check Pointed Seyed Are you selecting "Do not checkpoint run" option within the Job Activity Stage? If so, uncheck it. Kris, I just double checked and verified that for all three activities, the 'Do not checkpoint...

All, We have DataStage Job Sequence that runs our weekly Data Warehouse load and after 7-8 hours finishes successfully with no apparent errors. The trouble is that Oracle seems to still be updating some of the tables up to 1 to 2 hours after the job is finished. My co-workers and I believe that no o...

chulett wrote:Does your company have any kind of an "Enterprise" scheduler? ...

Craig,
Other than DataStage Director, I am not aware of any other Enterprise Scheduler that our organization utilizes.

Thank you for your help,

Seyed

The "skip job #1" piece is an inbuilt capability. Select the "include checkpoints for restart" option in job properties of the sequence and recompile. The one before another is managed simply by hav ... Ray, thank you for responding to this post. I am looking at the job properti...

What kind of target columns do you have? You'll primarily see this with CLOB or unbounded NUMBER fields, from what I recall. Craig, Thank you for your response. Please see my respond to Ray's comments. In it, I have listed the transform in two sections (source and target). It might help you detect ...