DSXchange

What version of pxEreplace did you use? DSGuru2B's original, or mine?

Error message : CopyOfjs0301020Fiserv_Extract_SrcStm_to_File..JobControl (@Job_Activity_429): Will execute error activity: ehGenericExceptions Is that message from the master Sequence, or from the called Sequence? The stage that is causing the problem is the Job_Activity_429 stage, so check that jo...

I selected "Server" for Job Type on this post, although I exclusively use this technique for Sequence Jobs. The Situation: A datastage interface consists of one or more Sequence Jobs, one or more of which is restartable. Typically this will be an Extract, a Transform, and a Load Sequence. ...

ray.wurlod wrote:As a general rule properties that can take their value from a drop-down list cannot be parameterised.

I thought that might be the case. I've worked around by having two DB2 target stages and controlling the flow of data to one or the other with a job parameter.

In the DB2 Connector stage, can the "Write mode" be parameterised? If I try dropping a jb parameter in, it prompts me for User-defined SQL. Is that just in case the parameter specifies "User defined"? Does anyone know what form the parameter should take, if it is possible? Is it ...

Hm. As ever, you spend all day working on a problem, and as soon as you post a question online, the answer occurs to you. We are now setting the Array Size to 100 (as against the default 2000) and it's fine. At least when the next person searches for "db2" and "20252" they will f...

I am loading data into a DB2 table using the DB2 Connector component, with a write mode of "Insert then update". As I understand it, this should capture any -803 errors and do an update instead. What is happening is, I get 15 messags written to the log saying "Native Error Code = -803...

Hm... although it worked when the job canvas was only performing one lookup, but when I tried to build the Shared Container with two lookups on the job canvas, I get "Error preprocessing Shared Container stage" when I compile it. I suspect that this is unrelated to the unusual circumstance...

This may be equally applicable to Server jobs. I have a requirement to make two small parts of a very large parallel job work in one of two different ways - to either perform a sparse lookup to a DB2 table, or to do an in-memory join to a pre-extracted set of data. The reason is, sometimes files wil...

Well, if you trust the variable names to serve as documentation, it takes the input to the script and splits it up into a system name, a user name, and a password. The server name and appears to be optional, that's what the ? after the ) in the middle means. =~ m{\A (?: ([^/,]+) /)? ([^/,]+) (?: , (...

Sure I can. But I want to know how DataStage does it - what is the resolution, and therefore what is the chance that a value in a time or a timestamp will not round-trip through any given database. For instance, SQL Server stores the time component of a timestamp as a number of 1/300 of a second, so...

Does anyone know what the internal representation of the Time data type is? This says that there are two 5-byte representations. Five bytes? I haven't seen a numeric type with an odd number of bytes since the days of the BBC Micro!

As per my requirement I dont know the upto which the loop has to be run as this is to be calculated run time by the query (select (days(last_day(CURRENT_DATE)) - days(to_date('20120101','YYYYMMDD'))) from SYSIBM.SYSDUMMY1). Aslo we need to pass the same to the main job also. How I can do this? Writ...

zulfi123786 wrote:...as documented in the Ochestrate guide

There's an Orchestrate guide? I found some info in the Advanced Parallel Job Developer's Guide, and once I knew the answer I did find dsrecords documented in there, do you mean that?

Just as I hit "Submit", a solution occurred to me - have a look in the PXEngine/bin directory and see if anything rings a bell! The answer is: dsrecords.