DSXchange

chulett

I always explicitly format all fields for CRC32 consumption so there's no issues like this. You could reformat this one field to match the old format if need be, I would imagine. Wouldn't help with the characterset issue just posted, however.

chulett

The 8.5 Documentation wrote:-mode specifies the type of job run. NORMAL starts a job run, RESET resets the job, VALIDATE validates the job, and RESTART resumes a restartable job sequence from the last checkpoint using the original job parameter values. If -mode is not specified, a normal job run is started.

chulett

It means RESET and that's all it does so I'm surprised you're saying it also ran the job. You should only use it when it is needed, my launch scripts always check first and reset if needed and only then run the job. Three calls to dsjob are possible in that case: one to check the status, one to rese...

chulett

I struggled with the same occassional error some time ago. The problem is many things can return a 'false' ORA-08103 as noted here and the behaviour is dependant on your version of Oracle. We never got a fix for it and a simple restart 'fixed' the problem. If you want help with this: "Also few ...

chulett

Sounds like your parameters are not being resolved, are you using the exact same spelling (case included) between the SQL and the job parameter's name?

chulett

Just for clarification, you are using the DataStage CRC32 function, yes? If so, then I would think the issue would be in the formatting of the individual data elements - date formats, leading zeroes, anything of that nature would change the generated value. However, knowing nothing about your data n...

chulett

Jobs are stored across multiple tables, not just one. You are deleting one small part of the whole and (essentially) corrupting the repository in the process. The GUI (Designer) deletes it completely.

chulett

You do NOT want to be deleting jobs like that.

chulett

Why does every question you post look like you are fishing for interview answers?

chulett

What above point, exactly? If you are unsure which 'direction' the Column Import or Column Export stages go, why not simply check the documentation? It is stated quite clearly there.

chulett

Of course, no-one assumed it was static. Answer this: how does the job know what filename to use each time it runs? Is the current filename passed in as a job parameter or are you using some other mechanism?

chulett

What about Ray's advice? Are you not passing in the filename to read as a job parameter? If so, simply leverage that in the appropriate column.

chulett

Each job stores its own status in a separate table. If you need to check everything all the time, script something or build a BASIC routine. The API will allow you to get a list of all projects on the server, then you can iterate through the list of projects and get a list of all jobs in that projec...

chulett

Thanks Ernie... I had made a mental note to mention that as well and then managed to forget it mid-post, it would seem.

chulett

As with most things, there are many ways of skinning cats, including this one. Glad you found a way that's working for you.

Search found 42189 matches