DSXchange

.. I am using a User defined query in the DB2 Enterprise stage to extract data and i am trying to throw it to a dataset..i do not have nay operators in between.. Db2 enterprise( Exec Mode: Sequential) --> dataset( exec mode: Parallel) ( usr defined qry) I get the follwoing error.. main_program: Fata...

hello all,

i am using the DB2 Enterprise ( write, append) to insert data into an empty table.

My PX Job aborts with the following message..

Error when checking operator: Operator of type "APT_DB2WriteOperator": The input partitioner attached to port 0 was destroyed

any ideas ??

Thanks.

guys,

has anyone come across the following error.. I am using a User defined query in my DB2 API to pull data and throw it to a Dataset..

Fatal: SQLAllocHandle: Failed to allocate environment handle 'ENV'.

all inputs are welcome..

thanks

.. this is not new in PX.. i believe that the data spitting out of ur Server Job may not be fixed length or if it is.. then u not plugging in the Meta data correctly in Ur seq file ...u need to play with all the options in the seq file to view the data..try using an implicit file type...also if it i...

rich.. .. i have observed that the lookup stage does not throw out a null when the lookup is not found, it just passes an empty string with the Continue option in the lookup stage.....Now we will be looking at a function that converts an EmptyString to NULL..i am not sure weather we have this... Tha...

..hi. .. lets say we have the following requirement... ..there is a decimal field in ur CFD (u r reading from a Mainframe file) say X..and in ur job u perform a lookup where one of the reference links is from a LkpFileset..now what u have to do is .. when the lookup is successfull, u need to get the...

guys, does anyone know weather we can use two embedded explicit conversion functions in one specification in a modify operator.. i have tried this but the modify operator gives an error.. ..moreover i have also observed the when i do an implicit data type conversion which is legal..i get a warning i...

does anyone know what the following error means.. I am trying to read a file from Mianfram system which has been put onto my Unix .. i have the CFD plugged into the Seq file stage and am trying to view the data.. the complex clmns are flattenned out.. 'The current soft limit on the data segment (hea...