DSXchange

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...

Scope wrote:i think your parameter 'BD' datatype is date.change the parameter type to string.

No.
The parameter data type is String only.

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 ...

bikan wrote:As per me tour query should look like

select
BUSINESS_DATE

from saggbp2.etl_business_time

where BUSINESS_DATE in ('2008-11-26','2008-11-28','2006-01-01')..b

Thanks.

It works when we harcode the values.
But the problem is when we use it as parameter.

try by enclosing date into single quote.......& using or function Thanks. I tried enclosing it in single quotes as well. But the stage i guess considers the entire parameter as string and does not fect any records. I am not sure how can we use or function here because i will not be knowing the ...

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...

Most likely that "/opt/IBM/InformationServer/Server/Datasets/" has filled. ... Are the datasets created in above folder automatically whenever error occurs or they are always created there irespective whether error occurs or not? will it be a good idea clearing the datasets in the above p...

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...

attu wrote:Reason code = 3 means, check diskspace to run load, database is full, clear the database

Does this mean this process will always need to be done manually when ever such failure occurs.

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...

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...

ray.wurlod wrote:Remove Duplicates stage gives the capability to preserve the first or last in each group. ...

So i will need to use Remove Duplicate Stage along with Aggregator Stage to meet this requirement and this functionality cannot be achieved in 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...

There was a carriage return at the end of the value for the parameter for dataset directory.
Hence It was giving that error.
Now the problem is solved.

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...