DSXchange

Craig has already recommend the preferred method, using DataStage to read and work on this file. There are a number of DS/Basic routine calls which let you open, close, read records or even read bytes from sequential files; but they involve a lot of programming and testing unless you have done this ...

Can you compare your two uvconfig files to see if they are identical?

If the job can be run as a multi-instance one then do so; it makes maintenance a lot easier. Some jobs, notably those with output stages that cannot be written to concurrently (i.e. sequential files), do not lend themselves to parallel runs.

What error message is being generated, and from which stage? Do you have NLS installed and if so, which character set are you using?

This would be a good place for a shared container - as miwinter has already pointed out, it would make maintenance easier as the code is only in one location; this is just the same as using a common subroutine in another programming language. Changes to the shared container only become active when t...

Transform stages can use stage variables to store values (i.e. to aggregate or compare values). If you have a stage variable MaxSalary that states "IF In.Salary > MaxSalary THEN In.Salary ELSE MaxSalary" that variable will contain the highest salary encountered in the run so far.

Duplicating threads does not help, see your other thread for details.

This thread should be closed.[/url]

This could be a deadlock type error. Try
(a) setting your commit frequency to each row, using $APT_ORAUPSERT_COMMIT_ROW_INTERVAL
(b) putting a reject link to your output Oracle to see if you get any errors.
(c) find a DBA to see if you have any Oracle activity or locks while your job is running.

Does a "DB2 CONNECT ..." to the XMETA instance from the command line on the DataStage server work or do you get an error there as well?

Neither type says anything to me as part of DataStage. Could you post one or two examples with full pathnames (and please STOP SHOUTING AT US).

Aakash - are you still with the same company? I think it was on Solaris that the "file" command gave 32/64 bit information; obviously I was wrong about AIX. I don't know other commands by heart anymore, but if you have "dbx" installed that will tell you. If it is mentioned that 8...

I wish I had DS on this machine, at least the documentaton; the function is either "RND()" or "RAND()" but I can't recall which. You can also SEED the series to ensure that you get reproduceable results. As asked before, if you wish to get unique customer IDs then using a random ...

If you take the problem a step at a time it might turn out to be a simple solution. What text is contained in this field in the CSV file? If you define that field as VarChar of appropriate length, what is displayed in the sequential file stage with view data?

Once again, all capitals is considered SHOUTING. This site is used as a supplement to training and experience and doesn't serve as a complete substitue for it. Writing routines is documented in the literature and taught as part of the DataStage courses. I think that, for the most part, the posters h...

Once again, using all capitals is considered SHOUTING, and "U" might be valid on SMS messages but not in a professional forum such as this one. A normal time field contains only a value and no GMT/UTC offset , if you need to account for this then you would need to add it. In some databases...