DSXchange

I think what he wants to do gateleys is to pass that cod as a job parameter to the select statement to just select those records which satisfy the where clause. Tiagogen: You need to build a unix script to read those numbers one by one and pass it as a job parameter to the dsjob call. That will giv...

The source won't have any rejected records, but when writing to the target in PX you can (in most cases) put a link coming out of the target stage that will contain the rejects. This is documented in the Parallel Job Developer's Guide in the section for the particular database stage. Hi ArndW, If m...

[quote="atulghate"]As far as the warnings are concerned, they are not because of data. Warning like sequential file can not preserve partition (I tied everything for this, doesn't seem to go. Another one is upsert will reduce array size to 1 for stage. ) quote] Warning of Preserve partitio...

ray.wurlod wrote:Another possibility is a Column Generator stage. ...

If the requirement is to just add a new column to the taget then Ray's suggestion would be better as transformer takes a toll on performance.

As mentioned, define what is 'bad record' in you case? Is it alwasy 6th and 7th in order? Chandra, Bad Records is purely a relative term. It depends on your business requirements. The record which one business calls as bad record may not be a bad record for another. Some of the common scenariaos wo...

I wonder why the links during processing of records always shows as n rows/sec , when actually it is the total records that has been processed. Why is the /Sec required anyways because we will be more interested in knowing if all the records have been processed or not and not at what speed it is pro...

Also check if any of the jobs with different invocation id is still running for this job. If so stop that job and then try compiling the original job.

Hai In which seneario will be used Filter and switch stages.which one is better for performance issue considerations. Well SWITCH is like your CASE statement in C or an EVALUATE statement in COBOL wherein when the condition is met, exit is taken. FILTER is used to drive an input to many different s...

From memory there's an environment variable called something like APT_PAD_CHARACTER (maybe APT_STRING_PAD_CHARACTER). You can set this up as a job parameter so that you can override it just in one jo ... It worked with $APT_STRING_PADCHAR. Thanks bandish and Ray. But if i want to set this varaible ...

Hi All, I am using db2 enterprise stage to load data from a sequential file in fixed length format. My database has some fields which are char(30) type. When i load data to these fields some junk characters are coming if the length of the data is less than 30. i.e. if source data is "abcdef&quo...

The only reason for this is that the variable is not available in parallel jobs. If it were it could only mean "the row number on this processing node" - for N processing nodes there would be N instan ... If @INROWNUM variable doesn't work in PX, then what is the work around available to ...

Thanks Arnd! I was able to get the job log details loaded onto a file with dsjob in UNIX. But can you please tell me where these hashed files exist in the server. Regards, Rony Hi Rony, Could you please share the code or syntax - how you did get the log details to flat file using dsjob in unix. Tha...

Thanks Arnd! I was able to get the job log details loaded onto a file with dsjob in UNIX.

But can you please tell me where these hashed files exist in the server.

Regards,
Rony

Hi All,

When we run a job in DataStage job log can be viewed in Director. But where will these same information stored in UNIX? Will it be stored as a file? If so then can anybody please tell me what is the directory PATH where i will find the file in UNIX.

Thanks & Regards,
Rony

Thanks to all. Kenneth, my requirement is absolute minimum. I want to see the product work on my Desktop which is having a WinXP(Pro). I don't have access to a UNIX server. Can i still have both the client and server installed in the same machine and work with Parallel Extender. The confusion is bec...