DSXchange

I was looking for a regex find C function like that by John McKeever (matchRegexp). I compiled this in Windows successfully, using ccx, MKS-Toolkit regex.h include lib. I then created a custom parallel routine in Datastage which seems to work fine for certain cases. For example matchRegexp("605...

I incorporated all the stages in a simple Server job (no shared container). The XML Input has a reject link, and the rejects are appearing in the reject flat file as expected. However, the job is still aborting on a Fatal error (in this case, a bad zip + 4 format). RHP_Sample_Server_Job..XML_Input: ...

I'm using a server shared container within a parallel job. The container reads from a folder object to get the filename (pattern), and uses the XMLInput stage to parse into xpath. The XMLInput stage is set to validate input XML and I am logging rejects to a flat file. My XML header has an entry for ...

Just ran into the same situation, although the embedded double quote is escaped by another double quote (which by the way, is CSV standard). http://en.wikipedia.org/wiki/Comma-separated_values DSEE does not seem to be able to handle an escaped, double-quote situation like "1234","1XYE...

I've seen situations where a deadlock occurs when there are multiple rows incoming with the same keys. If ORACLE stage isn't partitioned by the key, then it's possible for an upsert operation to occur on the same record in two different partitions (nodes) and thus using 2 different oracle connection...

Oracle patch did not work - was rolled back. Still working with Oracle support on this...

chulett wrote:Double-check the Oracle client versions on each server that you are leveraging for DataStage, that's usually what bites people. ...

We just got a note from Oracle asking us to apply a patch. This may be an Oracle issue. I'll post the results...

chulett wrote:What's different between the two environments? Are they on different servers? If so, what is different in the Oracle environments? ...

We are doing an exhaustive comparison between Dev and IT and have not found any DSEE or Oracle configuration differences. They are however, on different servers.

Have a situation where we have a timestamp column with valid date values. When it's written out to Oracle 10g using the Oracle EE stage, the target DB column (which is type date) shows different date values in that column. Some of the target values are valid dates, and sometimes they are wacky dates...

JoshGeorge wrote:Using GetEnvironment(%envvar%) we can get around this issue.

EX: GetEnvironment('APT_CONFIG_FILE')

Thanks ! Tthis works just fine.

jstrobel, thanks for the detailed description on how project level parameters work. I was more interested in the specific variable name and value setting you were having problems with, particularly since I thought you might have been using a name (instead of value) of $PROJDEF. But that is a moot p...

I'm not sure what you mean, could you post an example where you use the parameter in a transform? ... Sure. Suppose you have an identifier that you want to stamp on all records updated or inserted by jobs in a given project. You might set up a project level user-defined variable and assign a fixed,...

Welcome aboard. When you assigned the value to the stage variable, did you use the Expression Editor? If not, check thoroughly for misspelling. ... Yes, I selected the job parm from the expression editor (no typing). It accepts the parm (expression not red), but then won't compile. I've contacted I...

I am having problems compiling a parallel job with a parallel transform stage that uses a job parm imported from the project level. In other words, the job parm has a dollar sign preceeding it. I am simply assigning the job parm to a stage variable derivation. The compiler does not seem to like the ...