DSXchange

Hi, I have a decimal column of format Length=16 and Scale=6 coming from a text file. There is a check in the Transformer stage in the derivation tab as "If Trim(In_Col) = 0 Then Space(17) else Trim(In_Col)". But the check for ZEROES is not happening, but when i changed the check to "I...

Hi all,

Thanks for the replies/info.

Regards

Hi Felix,

Thanks for the info. But i am using a Transform procedure. If possible can u plz provide a simple example on how to achieve it.

Thanks

I need to call a Stored Procedure stage where my input is 3 params and output is 2 parameters one of which is a Cursor which is returning a 3 row-2 col result set. Can anybody tell me how to catch the output result-set in the STP stage? i.e. how to define in the PARAMETERS Grid? Please let know. The...

Did you import the stored procedure definition into your project and Load it (as a "table definition") into your job design? Have you tried just sending the three input values, and receiving back the ... Yeah I hv done that. I made a few modifications to d job and rite nw i am getting the...

Hi, I am using a Stored Procedure stage which calls a Stored Procedure in Oracle which requires 3 Input parameters & outputs 2 parameters. I am picking the values for the required 3 I/P parameters from a text file and for the 2 O/P params NULL is being passed. I am encountering the following err...

Here you go!!! <?xml version="1.0"?> <Msg> <ApplHeader> <ApplRef>4605779667529356871</ApplRef> <ApplParentRef/> <ApplOriginalRef>4605779667529356871</ApplOriginalRef> <ApplMsgType>HPSettUld</ApplMsgType> <ApplTimestamp>20060728103020</ApplTimestamp> <ApplOrgId>NAG-GSS</ApplOrgId> <ApplBran...

Read the messages carefully. There is a limit of 100000 bytes currently in force. To read more than that you will need to change something. Can you post the record schema associated with the Sequen ... I am using SQLType:LongVarChar & Length:500000 to read the XML file in the input column. I ch...

Hi, I am reading an XML file of 32KB thru a SEQUENTIAL FILE stage into a single column of length 500000. The TAGs are proper. But I am encountering the following Import error. Can anybody please help me out in this. Thanks in advance. WebSphere_MQ_8,0: Warning: WebSphere_MQ_8: Could not retrieve val...

I have a FILTER stage which has 2 output links,LINK1 & LINK2. Depending on the FILTER predicate either LINK1 or LINK2 is chosen. I am facing 2 problems/issues out here. 1. Even if one LINK is chosen after the FILTER stage the job is creating 2 output files one for each link. The first file creat...

Hi, I am trying to filter around 200 records using the FILTER stage on the predicate FundCode = Fund. These 2 are input columns which are VarChar(2) & VarChar(6) respectively. This is not working. I also tried with Trim(FundCode) = Trim(Fund) again with no positive results. I guess TRIM cannot ...

Hi, I am trying to filter around 200 records using the FILTER stage on the predicate FundCode = Fund. These 2 are input columns which are VarChar(2) & VarChar(6) respectively. This is not working. I also tried with Trim(FundCode) = Trim(Fund) again with no positive results. I guess TRIM cannot b...

ray.wurlod wrote:Anything to do with "heap" is about allocation of memory resources.

Either install more memory in your server(s), or reduce overall demand for memory, perhaps by running fewer jobs simultaneously, ...

Thanks Ray ...

Hi all, I am repeatedly getting the following error while I am trying to run a parallel job. Please giv me some leads. Thanks in advance. APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_BadAlloc: Heap allocation failed.. Operator signalled one or more errors. Regards, Durga