(single line)
cmd = "SELECT DS_JOBS.NAME AS JOB_NAME,EVAL DS_JOBOBJECTS."if index(@RECORD,'POPAPPL.ANALYSIS_VERSION',1) > 0 then 'FOUND' else 'NTFND'" FROM DS_JOBS,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO;"
Search found 48 matches
- Fri Jul 20, 2007 12:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Routine Sql to list all jobs linked to specific table-fails
- Replies: 15
- Views: 7350
- Thu May 31, 2007 12:45 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Data sample creation not yet complete for table "tablen
- Replies: 4
- Views: 3557
- Thu Mar 29, 2007 6:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to call teradata storeprocedure in datastage-px
- Replies: 3
- Views: 3402
Re: how to call teradata storeprocedure in datastage-px
[quote="oracle"]Hi Guys, I have requirement call teradata storeprocedure in datastage enterprise edition. i had tried with datastage stp stage. but it specific for oracle database only. please help me how to call teradata stored procedure using datastage-px Thanks & Regards Lakshmi[/qu...