DSXchange

I got the same issue. check if you have selected the multi-node option and the report progress option. apparently these options coupled with the reject option for data cause the warnings. As far as i've seen, no solution is available but if i find something, i'll let you know.

Am not sure if any action will be taken on this. Am just changing my jobs that touch that table to handle this issue. This had a cascading effect where all the jobs reading from or loading into the table started failing.

This had nothing to do with Oracle. I had earlier changed one of the jobs loading into the table to handle one of the columns as BigInt instead of Integer as i was getting negative values while using integer and the data according to Mainframe was a type Int64 (S9(10)). Due to this change, DS is not...

The exact error message: SchedTbl_Ora_conn,0: The OCI function OCIStmtFetch returned status -1. Error code: 3,113, Error message: ORA-03113: end-of-file on communication channel. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,009) The OCI function OCITransRollback returned status -1. Erro...

I am doing 2 lookups in the following fashion: 1) Lookup if record is found or not. a) if found go to lookup 2. b) if not found then go to transformer where a column status is set and then to dataset. 2) Lookup to see if all the column values in stream match the lookup dataset. a) If found then to t...

Apparently its not only resource issue, but also related to NLS. Due to the way NLS settings are done during installation especially with Universe connectivity, if the Universe database is down, all the jobs will abort with this error. Once the Universe database instance was brought back up, the job...

Source is a file. Thanks! Quick and dirty way would be to put it on a staging table and then do a between statement where you can pass the year number as a parameter which would yeild the desired result. If you do not want to use staging tables then tell me more about this range. Is it always a dat...

I have to derive Multiple Rows from two columns based on Range : For Example: Source File looks like: Col1 Col 2 Col3 A 2004 2006 B 1999 2002 From this I have a derive a column (Col4) which should have all values within the range of Col2 and col3 So My Output file should look like: Col1 Col4 A 2004...

There are a ton of conversations here on the topic of that -14 or "Timed out while waiting for an event" error. Have you been through them? What solution was offered that there's a problem understanding? I'm assuming it was something along the lines of "run fewer jobs at the same tim...

The following is the error message: seq_ODS_UV_DISTRO..JobControl (@RPO_DBMAXDT): Controller problem: Error calling DSRunJob(ODS_DB_AUDITTIME.Retail_PO), code=-14 [Timed out while waiting for an event] seq_ODS_UV_DISTRO..JobControl (@Coordinator): Summary of sequence run 09:39:35: Sequence started (...

This has been happening more often that we like. This was the 2nd time in 2 weeks we got this issue. The reason why my superiors have a problem understanding the solutions you have provided is that Universe has been removed from the 8.1 framework and DB2 has been provided for managing the metadata. ...

ray.wurlod wrote:You've just reinvented the MAXIMUM() function.

I needed the dynamic array as result which is the largest among all the columns that i am comparing.

If you want the maximum count, no. Figure out your actual requirement and deploy the appropriate functions. I've suggested the most likely. The following is the result that i deployed as a server routine: Function TestCompare<Arg1> MaxCount = 0 PosOfMax = 0 NArgs = dcount<Arg1,"|"> For i ...

Does it have to be 20 columns, or can you get them as one column? If not, assemble a field-mark delimited dynamic array containing the 20 columns. Apply the Counts() function to return an equivalent dynamic array of the number of value marks in each field (you may need to convert to a non-delimiter...

I'd be surprised if you could actually pass @SM or @VM characters into the test harness correctly. :? I have not passed any @VM or @SM expressions. i have passed the equivalent delimiters that are provided by the view data from DataStage. This shows that DataStage masks @VMs as @SVMs which is incor...