Search found 28 matches
- Wed Nov 26, 2008 5:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WHERE DATE in (StringParameter) in DB2 Stage
- Replies: 12
- Views: 5023
Your job parameter needs to have the intermediate quote characters. '2008-11-26','2008-11-28','2006-01-01' ... Hi Ray, Using the code select BUSINESS_DATE from saggbp2.etl_business_time where BUSINESS_DATE in (#BD#) Where BUSINESS_DATE - Of Type Date #BD# - Of Type String I pass The value for the P...
- Wed Nov 26, 2008 4:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WHERE DATE in (StringParameter) in DB2 Stage
- Replies: 12
- Views: 5023
- Wed Nov 26, 2008 4:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WHERE DATE in (StringParameter) in DB2 Stage
- Replies: 12
- Views: 5023
try this select BUSINESS_DATE from saggbp2.etl_business_time where BUSINESS_DATE in ('#BD#') pass the value :arrow: 2008-11-26','2008-11-28','2006-01-01 in the parameter Tried it. Did not work. Got the following error. DB2_UDB_Enterprise_0,0: Error Idx = 9; DB2Driver Embedded SQL message: SQL0180N ...
- Wed Nov 26, 2008 3:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WHERE DATE in (StringParameter) in DB2 Stage
- Replies: 12
- Views: 5023
- Wed Nov 26, 2008 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WHERE DATE in (StringParameter) in DB2 Stage
- Replies: 12
- Views: 5023
- Wed Nov 26, 2008 1:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WHERE DATE in (StringParameter) in DB2 Stage
- Replies: 12
- Views: 5023
WHERE DATE in (StringParameter) in DB2 Stage
The SQL query required in DB2 Stage is select BUSINESS_DATE from saggbp2.etl_business_time where BUSINESS_DATE in (#BD#) #BD# - Is parameter containing comma separated values of date of type string. Eg:- (2008-11-26,2008-11-28,2006-01-01). But it did not work in DB2 stage. The Job aborted. I tried c...
- Thu Aug 14, 2008 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Write To Dataset Failed. Broken Pipe
- Replies: 4
- Views: 6845
- Thu Aug 14, 2008 4:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Write To Dataset Failed. Broken Pipe
- Replies: 4
- Views: 6845
Write To Dataset Failed. Broken Pipe
The Job Design is DB2(Read)-->cpy-->Dataset(Write Append) No of Records 578056. The job is getting aborted giving the following error. APT_CombinedOperatorController,0: Write to dataset on [fd 28] failed (Error 0) on node node1, hostname huxd0208 APT_CombinedOperatorController,0: Orchestrate was una...
- Thu Aug 07, 2008 2:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterprise LOAD APPEND
- Replies: 2
- Views: 1919
- Wed Aug 06, 2008 1:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterprise LOAD APPEND
- Replies: 2
- Views: 1919
DB2 Enterprise LOAD APPEND
Hi, The Load job design Dataset--->Copy Stage---->DB2 Enteprise (LOAD APPEND method) The job aborted giving the following error "SQLCODE = -668; SQLSTATE=57016/tmp Operation not allowed for reason code "3" on table SQLSTATE=57016" The table was in inconsistent state as the reslut...
- Wed Mar 12, 2008 5:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Stage
- Replies: 6
- Views: 1940
INSTEAD of Aggregator stage. ... Sorry I forgot to mention that i have some other columns F,G on which i need to aggregation for SUM and COUNT. And for Column E i need to retain the First value in that group. So I wanted to find if any such function for retaining the FIRST value is present in Aggre...
- Wed Mar 12, 2008 4:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Stage
- Replies: 6
- Views: 1940
- Tue Mar 11, 2008 11:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Stage
- Replies: 6
- Views: 1940
Aggregator Stage
In Aggregator Stage i am passing five input columns A,B,C,D and E. I am grouping on A,B,C,D keys. After Grouping i want to retain the First Value of E in the group. Is this possible? If possible which aggregate function to use? because in Aggregator stage i did find any specific function to retain t...
- Mon Jul 09, 2007 5:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error writing ORCHESTRATE File Data Set descriptor
- Replies: 2
- Views: 8474
- Sun Jul 08, 2007 9:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error writing ORCHESTRATE File Data Set descriptor
- Replies: 2
- Views: 8474
Error writing ORCHESTRATE File Data Set descriptor
In a job writing data from Database(DB2) to Dataset it is giving error as :- Unable to open descriptor file to create: No such file or directory.: Error writing ORCHESTRATE File Data Set descriptor.Fatal Error: Could not create output file. The dataset property is overwrite.The File directory also e...