Search found 331 matches
- Thu Jun 25, 2015 12:35 am
- Forum: General
- Topic: Datastage path and export clarification
- Replies: 5
- Views: 3950
- Wed Jun 24, 2015 10:59 pm
- Forum: General
- Topic: Datastage path and export clarification
- Replies: 5
- Views: 3950
Datastage path and export clarification
I have read one post in Dsxchange long ago where if we gave input dsx file as input through macro in excel.Then it will show all jobs and their path in excel.I did not remember that link.i tried in search option but no luck.Could anybody provide link for it
- Sat May 09, 2015 2:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: selecting one record out of 2 records
- Replies: 16
- Views: 11545
- Wed May 06, 2015 9:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: selecting one record out of 2 records
- Replies: 16
- Views: 11545
selecting one record out of 2 records
I have data as mentioned below.source is sequential file source,destination,distance chennai,hyderabad,500 hyderabad,chennai,500 chennai,bangalore,600 bangalore,chennai,600 chennai,bangalore,600 I have to select 1 record out of 2 records.ay record is fine. chennai,hyderabad,500 hyderabad,chennai,500...
- Thu Apr 16, 2015 4:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trim function clarification
- Replies: 2
- Views: 2805
Trim function clarification
In user variable activity following derivation is defined Field( Trim (EReplace(Get_Extract_DTTM_Param.$CommandOutput,@FM,""), ("":'"':"") , "A") ,"|",2). Can anybody explain what trim will do in above case.basically i did not understand below p...
- Wed Apr 08, 2015 5:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Condition
- Replies: 5
- Views: 5134
- Wed Apr 08, 2015 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Condition
- Replies: 5
- Views: 5134
Lookup Condition
I have two tables table1 and table2.Lookup stage is used between table1 and table2.table1 is master link.In lookup stage we have following properties Condition is table2.Col2='ABC',condition not met=Continue and Lookup failure=Drop. I want to convert above logic to sql.Any body help on this.I know h...
- Tue Apr 07, 2015 3:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NZ sql script calling
- Replies: 6
- Views: 4387
- Mon Jan 05, 2015 4:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NZ sql script calling
- Replies: 6
- Views: 4387
I believe following settings are sufficient to handle my scenario after reading the documentation and please correct me if i am wrong? Fail on error=YES if you specify Fail on error as Yes, all statements are executed as one transaction. If one fails, the statements already executed rolls back and t...
- Fri Jan 02, 2015 4:04 am
- Forum: General
- Topic: Parameter set replacing values
- Replies: 2
- Views: 2743
Parameter set replacing values
I have one parameter set with different value files ex-P1 is parameter set and dev1,tst1,prod1 are value files for P1 select col1,col2 from #P1.tablename# I have to replace #P1.tablename# with corresponding value from value file it may by dev1,tst1,prod1.we are calling above sql statment using NZ co...
- Fri Jan 02, 2015 3:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NZ sql script calling
- Replies: 6
- Views: 4387
NZ sql script calling
I am new to netezza and i have one sql file consists of following statements which we are calling from NZ connector[Read from sql option] Insert statement1 Update statement1 Updatestatement2 I want all 3 sql statments should be success and if any sql statement is failed i want to rollback all the sq...
- Fri Jan 02, 2015 12:04 am
- Forum: General
- Topic: @FM clarification
- Replies: 14
- Views: 28776
- Thu Jan 01, 2015 11:27 pm
- Forum: General
- Topic: @FM clarification
- Replies: 14
- Views: 28776
Thanks all for input and just want to know my understanding correct or not. 1)cat temp.txt 1,2 3,4 In notepad++ i can see above file as 1,2CRLF 3,4CRLF As per ArndW,datastage will replace @FM[CRLF] with '' when i use Ereplace(Cmd_CheckRejectSize.$CommandOutput,@FM,'').Is my understanding is correct?...
- Thu Jan 01, 2015 11:15 pm
- Forum: General
- Topic: Datastage show performance statisces clarification
- Replies: 4
- Views: 3296
- Wed Dec 31, 2014 4:29 am
- Forum: General
- Topic: Datastage show performance statisces clarification
- Replies: 4
- Views: 3296