DSXchange

thanks for your reply

both environment are same. Could you please let me know whether I need to check any environment variables?

thanks for your reply

one of the column in the file is comeing as 'PARK G^ZELL '.

Hi, my job is sequential file -------> teradata connector stage. we are getting control characters in the file. we are unable to load the data into the table apr from ^Z characters. we want to load ^Z characters also. In the produciton job is failing. But in the development ^Z characters are loading...

Hi, terdata Upgrade was happend recently in the produciton. Before terdata Upgrade job is runing fine. After that job is failing with below error. error message: [IIS-CONN-TERA-005004] RDBMS code 220: Completed successfully. SQL statement: SELECT it is throwing error while extracting the data from t...

thanks for your reply

suppose schedule time is 6:30. it is triggering at time (no second different).

even that time also will jobs will run?

Hi,

in production one sequence is running with three differnt invocation ids in production(4 nodes)

I think one job will run and remaining jobs will fail

please confirm that

Hi, job template has been given by client. in this job they are useing perl script by useing command stage activity. if run the job it is showing perlscript.pl (perl script name) command not found. If I added perl before the script name it is working. I can not change the template. it is working in ...

after executing above two commands I have taken copy of the job.
I was able delete the job in designer(including copy of the job). I think there is no entry in ds_objects. please correct me if i am wrong

what is mean by orphan records? can you explain clearly

yes I am working on 8.5. but small correction.

DELETE FROM DS_JOB0BJECTS where name='jobname'

DELETE FROM DS_JOBS where name='jobname'

HI,

After executing below commands I am able to delete the job.


DELETE FROM DS_JOB0BJECTS where name='jobname'

DELETE FROM DS_JOB0BJECTS where name='jobname'

my problem is solved.

Hi,

My job is corrected. I am unable to rename and delete the job.

I went through below link. I followed same what they are telling. But It is not working for me.


viewtopic.php?t=113012

Please help me

Hi jwiles ,

thank for your mail

Is this approach will work on two nodes or four nodes also?

sorry ,Small correction Use a copy stage to split the incoming records into two streams. One stream goes to an Aggregator stage that groups the records by key field(s) and counts the number of records in each group and outputs the results to the COUNT field. The output from Aggregator stage is then ...

hi, I have to implement below logic in datastage(not with custom query) SELECT COL1 FROM DBASE GROUP BY COL1 HAVING COUNT(*) > 1 . as of now iam following below approach. Use a copy stage to split the incoming records into two streams. One stream goes to an Aggregator stage that groups the records b...