DSXchange

Hi ! I was trying to do some fancy stuff in response to a query posted on this forum. The issue was to split a string Id, String 1, "a,b,c,d,e,f" as Id Value 1 a 1 b 1 c 1 d 1 e 1 f without really knowing the maximum number of "values" in the "String" I tried to design ...

I've never worked on DS installed on Windows Servers, But I think creation of users should be as simple as creating User Accounts in windows.

If I remember correctly, the password for Oracle Database should be between 4 & 30 characters.

The error you are seeing must be because of this.

Try to give a password of less than 30 characters and connect

Try something like

What is the Data type as defined in transformer for also let us know how are these defined Can you also verify the Lookup to the ODBC stage and check that the data types (and also value) of the fields being looked up are compatible.

when you reset the job, was there any message from "previous run"

are there any restrictions on your UNIX server that an process cannot remain active for more than 1 hour ? I may be wrong in my thinking, but I believe that the error you are getting is due to the UNIX process. It is getting killed. Can you do ps-ef|grep phantom and search for the Job that is gettin...

I remember this being a bug with Datastage 7.5.1A

Your look up using Hashed files would work correctly, but the look up against the OCI stage / DRS stage would result in the error "All Variables not bound".

I would suggest that you get in touch with IBM for the patch.

can you tell me what you mean by error log routines ?

Do you want to capture all the Datastage Warnings / Errors ?

If your source is a database, you can use the database functions to generate this column.

Eg: In Oracle

select add_months(sysdate,12) from dual;

will add 12 months to current date.

Hi, I am unable to give you a datastage solution diagram for this problem, due to lack of time, but here is the logic Input: a, b, c, 4, 5, 6 p, q, r, 4, 5, 6 Assume that a,b,c are your primary keys and 4, 5, 6 are 4th,5th & 6th columns (structure of these columns will be 4.1 4.2 4.3.. 4.n for 4...

Check whether there are any network glitches / system activity at that time.

You can look for these messages in /var/adm/messages

I think Microsoft telnet services is not started on windows box.

Try to start the telnet service (if its not already started) and then restart the Datastage Service

The -14 error indicates that a job start request was issued and that 60 seconds have elapsed while waiting for a record to be written to a status file. If the lock tables are too small the job will fail to start and you will get a -14 error. If the system is under a heavy load the job process may no...

You can find lots of tips on Performance improvement by using the Search facility.

There are tips like setting the Buffer Size, modifying the job design, partitioning the table etc etc..