DSXchange

Without a key what identifies the records to compare from one run to the next? If there is no natural key in the source field then all you can test for is whether their is already a record in the target that is exactly the same, in which case all fields are key fields??? Or is this a trick question?...

very good point Craig, that adds a whole nother level......

...also do you not see RED when a ROGUE process kills your project ...

Further to my previous reply, i could have been more help. you are looking for these records BEGIN DSRECORD Identifier "V0S0" DateModified "1899-12-30" TimeModified "00.00.01" OLEType "CHashedFileStage" Readonly "0" Name "Hashed_File_0" Nex...

Ray one other question

If I was to only update the prodUser so they have DBAUTH privaledges would that be sufficient for the system to work correctly, i.e. prodUser to be able to create/delete projects, or does the prodUser need to be owner for the Catalog tables?

Ray, When writing to a hashed file using the PATH method, what would datastage use as permissions? would it not just check file level permissions? or would it know that I am trying to write to the UV_USERS file which is one of it's system tables and prevent it? If it is the case that DS knows this i...

I'm not 100% about this and have no system to test it on but I think all the data will still be read if the dataset has been created on 4 node and you then read it on 2 node, but you will get a warning about the data being repartitioned, hence loosing performance. (And there will be a warning in the...

I need to compare the pogstatus.if the pogstatus is the same

compare which pogstatus to which pogstatus? Your second table doesn't have pogstatus. Do you mean the pogstatus for the same pogtype and customer from the last file/last run?

Explain a bit more.

Pradeep, The errors I'm talking about capturing inside the jobs would only be data validation types of errors. Is the field populated, Did the lookup return a value, Is the string too long is the date valid etc These sort of errors you can code to capture. Can anyone suggest me of capturing all runt...

whenever I request IBM support, they ask for the jobs to reproduce the problems at their installations, all types of jobs

what do you mean by that? are you implying that these people who are helping you for free should also send you any job you request?

If you're just talking about getting what is produced in the dirctor log into a flat file, run an 'After Job Subroutine' Routines\Built-In\Before/After\DSJobReport It has instructions on how to use it in the routine description section. If you want to get all errors detected within the job by your c...

Did you mean 'How to capture them in a flat file' ?

>##E TFIG 000000 11:48:59(009) <Sequential_File_0> At field "units": When validating import/export function: APT_GFIX_Decimal::validateParameters: the decimal "text" format is variable length, and no external length is specified; can you show us the definitions you have for the ...

EE can be such a pain in the arse with null handling. Try what I said in previous post and see if that get's rid of the first warning. You could also try adding in a modify stage between CFF and Tfm to change the fields properly from Non-nullable to nullable, or I think sometimes if you added in a c...

I'm pretty sure it's just complaining about the IsNull() on that field when it thinks it can't contain a null as it is not nullable.

What happend if you change it to
-- edited, got distracted

Do you have a reject link on the Xfm?? Is there null handling on that column def?