Search found 48 matches

by cundyp
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

SQL is in single line, sql without eval works.

(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;"
by cundyp
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

The following messages are displayed when profiling (Column Analysis) db2 tables over 350k rows. "Data sample creation not yet complete for table "tablename", Please try again later " or "The requested data is empty". The first step in CA results in creating the check b...
by cundyp
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...