DSXchange

Hi DS Guru's Have a challenge !!! I'm facing over here. I'm using one job level parameter file Like this: Parameter Name , Prompt , Type , Defacult Value EMAIL_ID_LIST, Enter email list, string, /dv/abac/DEFG/paramcd/email_params.txt Values In : Email_params.txt abcd.efecg@gmail.com, efcd.aeac@somwh...

Defined project level parameters...

I can get the values from parameters...Want to execute....that entire query

Advice me which stage support to run the query....

Let me know if I'm not clear to you !!
Thanks,
John

Hi DS Guru's, Have a challenge to run this below given query . Please help me which stage can be used to run the query ? If possible ...How to implement it in design. Query: variable b1 VARCHAR2(40); variable b2 VARCHAR2(40); exec :b1 := '#$START_DATE#' exec :b2 := '#$END_DATE#' select T1.ROW_ID AS ...

Hi DS Guru, Have 10 jobs in one sequence , Out them 2 jobs are failed. How to re-run my sequence , what condition have to used to re-run the whole sequence so that only failed jobs will run . Have to run the whole sequcen, But only the jobs which are failed in the previous run those should run in th...

ShaneMuir wrote:Is there a message handler which is suppressing warnings at all?

How to message handler !! will anyone help me in this.....

ray.wurlod wrote:Options -wait and -jobstatus are mutually antagonistic. Try removing the -wait option from the dsjob command, ...

Will try that option and let you know Ray !!

Thanks in Advance for all the support !!

Thanks,
John

Thanks,

Let me try this option !!

Regards,
John

Here is the Scripts which I'm using to run the jobs : Please Advice me if there are any changes needed. #!/usr/bin/ksh ######### # Define Parameters Files ######### . /home/dsadm/.bash_profile . /it/resrc_disk1/DS_OLTP_CRM/paramcd/OLTP_ds_ITenv_param.txt # Define log file SCRIPT_LOG=${LOG_DIR}/$(bas...

AND ROWNUM <=10 is given for the testing purpose...

Its pulling the 10 records....but if i gave the full query to pull the entire data its not pulling out......It seems its of Length issue or memory issue....Please advise on this.


Looking for your kind help in this regard.

Thanks,
John

Hi ,

Tried that option as well ...its pulling 10 records from the DB

If i removed that join condition it is not pulling all the data from DS

Please let me know how to go ahead..

Thanks,
John

No I didn't. I asked a question designed to find out where this code was generated. That question has not been answered. Ideally please post the wrapper script that AutoSys uses. Please also repor ... The log is not from the Datastage : The log is from the Autosys Log Log : sec17a3_siebel_Activitie...

We are running the jobs from Autosys !!

All DataSage jobs completed successfully !

Log got generated with this message : DataStage job failed with return code : 269

Any info on this.


Thanks,
John

This is happending because of Length and Data type issue

Long is the Data type and Length is 16383

Thanks in advance

John

Run the query as per your word !! its giving the result . In the TNS_ADMIN : I'm able to run the other jobs all jobs are pointed to ST database. Have 5 more jobs which has oracle connector those are working fine and giving the result... Concern is that Job is finishing successfully with 'Zero' recor...

qt_ky wrote:And just to take it one step further, double check the database entry on the DataStage server. If it uses a tnsnames.ora entry then check that it matches the tnsnames.ora entry on your client.

Everything is Mathes !!
Please suggest on this.

Thanks,
John