DSXchange

Hi Everyone, How can we list all the DS jobs which were using a specific environment variable in a project? We have thousands of DS jobs in our project and need to list all the jobs used by specific environment variable like #$SqlServerDSN#. I took the latest copy of .dsx file and manually searching...

Hi Experts, As i am extracting the data from my Oracle source (used DRS stage) to my target table (Oracle,DRS stage) for varchar fields, i am getting NULL values . And if i am extracting the data from my Oracle source (DRS stage) to my target (Sequential file) , I am getting first value of the field...

Hi Arndw, I checked the cron tab contents and below is the information which i get . 22 22 * * 1,2,3,4,5,6,0 /apps/Assential/Datastage/Projects/ProjectName/dsr_sched.sh /apps/Assential/Datastage/Projects/ProjectName /apps/Assential/Datastage/DSEngine JOB_NAME 0/50/1/0/0 3 >/dev/null 2>&1 #DSJobD...

Hi Chulett,

I unscheduled the Job and Add the job to schedule ,but the Job is not Running,still it is shows the status as Comiled. When i run the job manually it is Running properly.

Could anybody help in this,what might be the reason.

Thanks,
Ramu

Thanks You Chulett ,

I will Unschedule the job now and add back to the Scheduler.
I will let you know the status by tomorrow.

Thanks,
Ramu

Hi , I scheduled my Sequence job to run every day at 10.30 PM, previously the sequence Job was run daily based on scheduled time. But yesterday it has aborted because some database issue, then i compiled the Jobs which were aborted and Compiled the whole sequence. After that the sequence job is not ...

Hi , I am facing a similar kind of problem what Jayeeta is facing. I scheduled my Sequence job to run every day at 10.30 PM, previously the sequence Job was run daily beased on scheduling time. But yesterday it has aborted because some database issue, then i compiled the Jobs which were aborted and ...

Hi Friends,
We can use Keymgmtgetnextval also to create sequence values.

What is the difference between Keymgmtgetnextval and KeymgmtgetnextvalConcurrent?

Thanks&Regards
Ramu

Hi Friends, I am having two similar files in source with same metadata , FileNames like product1.txt,product2.txt. I am trying to read two files with Readmethod= FilePattern ,Mechanism in SeqFile Stage, with file name like product*.txt, and also tried like product?.txt. But Now rows were returned wh...

Hi ArndW

Thank You for your quick responce.

Regards
Ramu

Hi Friends, I am having 3 job activities say A,B,C in my sequence , after running of these 3 Job activities, i had a requirement to execute some batch file to load the Job activity C Target table to another Table which will reside in Database. Can I use Command Activity stage for executing the batch...

Hi Ray,

I allready mentioned the SMTP Mail Server Name in that and Senders and Recepient Mail addresses.

Please help me,in this


Thanks&Regards

Ramu

Hi Friends we are using Email Notification Activity in Job Sequence. after completing the sequence run we are not getting any mail, in log files we are getting message like below: Sent message to 'someone@abc.com' Executed command: /opt/datastage/Ascential/DataStage/Projects/greyhound_jde_new/sendma...

Hi friends,
I would like to do Certification on Datastage , can anybody please provide the details

Thanks&Regards
Ramu.Mandava