DSXchange

Hi,

We are using datastage director to schedule jobs.

I have an email notification routine, which sends an email whenever the job gets aborted.
here the issue is , I need to reset the job after ending the mail.
Can you please tell me how to do this in the routine

Thanks
Sri

I got it now.Thanks Craig

Craig and Ray -Thanks for your reply . Craig, as you said , I saved columns as text filed and loaded them into table now I see leading zeros. I don't understand the second option you mentioned "use a custom mask to force Excel to preserve the leading zeroes".Can you pease tell me how to do...

Hi , Our input data is in excel file, to read that file I converted to csv (comma delimited) but here is one issue, few columns have leading zeros in original excel file.When I converted to CSV , all leading zeros are disappeared.So I am not able to load them into target table. When I open it as a t...

hi my data is like this emplid name groupid 11111 Y UHH 22222 Z UHH 12345 x UHH 12345 X UHF 12345 X UHG 12345 X UHM 33333 M UHG Data is in sequential file.I used sort stage to sort the data Requirement is, we need to give the rank to group id if one employer belongs to more than one group.If there i...

HI,

this problem got resolved.I gave host name instead of service name

Thanks

Hi I added this entry in uvodbc.config <EPMDV> DBMSTYPE = ODBC in .odbc.ini added the following entry our database is oracle [EPMDV] Driver=/apps/Ascential/DataStage/branded_odbc/lib/VMor820.so Description=DataDirect 5.00 Oracle ApplicationUsingThreads=1 LogonID= admin OptimizeLongPerformance=0 Pass...

Thanks DSGURU2B.Now I see the file

HI ,

I am trying to import table definitions using odbe connection.
From the manual I came to know that we need to put DSN Entry in 2 files
odbc.ini,uvodebc.config files.
In DSHOME path I don't see the odbc.ini file.
Where can I get this from .Can you please let me know

Tahnks

Hi

when I am trying to open DRS Stage , job just hangs.we can run the jobs and view the stage from the designer . This happens only from one machine

does anyone have any idea ?

Thanks

I am able to solve this prblem.

Thanks Maveric for your help

Thanks Maveric for your reply.

I added sequence terminator Stage to the Sequence.Can you please tell me where to put the logic to trigger the terminator stage only ,when the job aborts.
is this in job control code.

Thanks

Hi, I have one routine activity and one job in sequence. 1 >When I ran the sequence, job in the sequence got aborted. but in the director , status of sequence is shown as finished and job's status is shown as Aborted.I wanted to see the status of sequence is also aborted.all compile options in the j...

Thanks Ray and Josh for your reply.

Actually We got old version text file from Peoplesoft which feeds this routine.

We addede few entries what we want to this file, now it is working fine


Thanks

Hi, when I ran the job, it aborted with this message "From previous run DataStage Job 6141 Phantom 12438 Program "DSD.RUN": Line 2157, Variable previously undefined. Zero length string used. Program "DSD.RUN": Line 2157, Variable previously undefined. Zero length string used...