DSXchange

You have marked your job type as Parallel. I am assuming that that is incorrect. It depends (on whether the hashed file is dynamic or static) but, since it's probably dynamic, then you need a different process. The "hashed file" - and please note the terminology - it's not "hash"...

Nothing shown in this thread is a DataStage schema file.

You can save schema files directly from the Table Definition record (in Manager or Designer in versions earlier than 8, in Designer in version 8 or later).

HOW big is the row (in bytes, not in columns)? You will find the size of each data type documented in the manual.

Once you know the row size, THEN you can calculate the optimal array size.

1. Search DSXchange for ideas about throughput performance. 2. Create a job that identifies which rows are to be inserted and which have to be updated/deleted. Bulk load the inserts. 3. Create multiple instances of your job each of which processes a proportion of the records. (Be very careful with t...

Either way, post the data types on the input link and the data types on the output link.

Welcome aboard. You won't get a timestamp without specifying a time part. You won't get proper handling of null unless you handle the null. For example If IsNull(InLink.TheString) Then SetNull() Else ... Given that the date is a string use string operators (substring and concatenation) to construct ...

This is basic, fundamental, operating system 101 stuff. It is totally unrelated to DataStage or Information Server. "Command not found" means that the operating system can not find the command, which means that the command's parent directory is not included in the command search list - tha...

Why do you believe the long description is in field #7? I suspect (without checking) that the long description is usually in field #5 (except for DS_JOBS). Anyway, to answer the question, you clearly have not been looking in the right places. Any particular field number can be extracted using the Fi...

Are you sure? The error message refers to hostname z2dquat1.

What is different between production and development? ("Nothing" is not the correct answer.)

Perhaps you can now mark this thread as Resolved using the green button at the top?

Add a reject output link from the Sequential File stage; this will capture any row that does not match the record schema for a detail record, and downstream stages on this link can re-parse for example to retrieve the dates and totals. record schema { policy_no string[8]; filler1 string[1]; table_no...

The installation is probably OK. ASB in this case is "Application Server Backbone", the layer provided by the WebSphere Application Server to deliver the services used by products such as DataStage to communicate with Information Server. I'd begin by verifying that the WebSphere Applicatio...

One hour left for what? DSXchange is an all-volunteer site whose members post as and when they can. You posted at 2am my time, there's no way I'm awake at that hour. If you need urgent help, sign up with your official support provider for premium service, and learn just how much "urgent" c...

Use a Column Import stage to do the parsing for you. Upstream the "first line is column names" (so ignore the first line) is asserted. Or trap that on the reject link of the Column Import stage.