Search found 246 matches

by hamzaqk
Wed Nov 26, 2008 5:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading the schema file
Replies: 8
Views: 2436

You don't import it. Just use the "Schema file" property under Properties->options to specify the schema.
by hamzaqk
Tue Nov 25, 2008 6:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Certification - Some basic questions
Replies: 11
Views: 3931

The code for it is 418. I took the version 8 certification last month. You need to read the documentation which ships with it for sure. DB2, Oracle and ODBC enterprise stages. NLS, MQ stage, Information Server Administration. Experience with Parallel job development for sure. i liked the paper as it...
by hamzaqk
Mon Nov 24, 2008 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage certification
Replies: 1
Views: 1298

I took the version 8 certification last month. You need to read the documentation which ships with it for sure. DB2, Oracle and ODBC enterprise stages. NLS, MQ stage, Information Server Administration. Experience with Parallel job development for sure. i liked the paper as its based more on practica...
by hamzaqk
Sun Nov 23, 2008 11:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in Teradata Conn when calling UDF
Replies: 6
Views: 3686

Have'nt asked for any patches for this yet. we just do it through views now. i.e. perform any such functions in views and then just do a select insert from there in the after SQL.
by hamzaqk
Sun Nov 23, 2008 11:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in Teradata Conn when calling UDF
Replies: 6
Views: 3686

Have'nt asked for any patches for this yet. we just do it through views now. i.e. perform any such functions in views and then just do a select insert from there in the after SQL.
by hamzaqk
Fri Nov 21, 2008 6:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two Jobs of same name error
Replies: 5
Views: 2006

two jobs with the same name wont be allowed. why have you created two jobs with a single name?
by hamzaqk
Fri Nov 21, 2008 6:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two Jobs of same name error
Replies: 5
Views: 2006

multi instance job ??
by hamzaqk
Fri Nov 21, 2008 5:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unmatched records Capturing
Replies: 9
Views: 2533

only merge and lookup stage allow us to capture rejects
by hamzaqk
Wed Nov 19, 2008 11:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in Teradata Conn when calling UDF
Replies: 6
Views: 3686

its a bug :D . and this is not the only one. if you use formatting, etc it will also come up with the same warning. in some cases if you run the job even though this warning is present it works fine .. cheeky :lol:
by hamzaqk
Tue Nov 11, 2008 6:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer Restartability
Replies: 5
Views: 1685

if you do it in the administrator the property would be set for all sequences by default :roll:
by hamzaqk
Tue Nov 11, 2008 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while loading data
Replies: 2
Views: 1809

thanks for the information :lol:
by hamzaqk
Tue Nov 11, 2008 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TPT(teradata parallel transporter) error
Replies: 4
Views: 3804

well its def not due to different developers using the same sync table. is the sync ID unique for each combination of job and table? on what basis are you specifying this value ?
by hamzaqk
Mon Nov 10, 2008 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to request the job (parallel, sequence) version?
Replies: 11
Views: 4198

dont copy paste your query in the DOS CLI. use the caps and type it. it will work as i just tried it.
by hamzaqk
Mon Nov 10, 2008 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing reject rows from teradata connector
Replies: 1
Views: 1634

drag a reject link out of the Connector stage. after this open the connector stage and click the reject link in the upper left corner where it says "select the link or connector to edit" and click "row not found" .