DSXchange

This can be easily accomplished by writing a basic routine which counts the number of records on a *link* attached to a *stage* in a particular *job*. However, keep in mind that it is best to run this routine after the job which does the loading. As for the routine you can find plenty of them on thi...

Do you have 2 datasets or are you appending one dataset to the other?
If you have 2 datasets which are not being appended you will have all the same keys in the same partitions.

When you say you are returning "1" do you mean you have an "exit 1" in your script? If so, this behavior is expected. You see, if the script exits with a status other than 0 (0 for success) it signifies an error. That's the reason your sequence is throwing up a warning. Try chang...

The 'Field' function should be able to do this. I don't remember the syntax, But it has the delimiter, the field number and the input string as its arguments.

Field(ip.string,'.',1)

I have posted the final requirements for the tool dsSurfer. I'll put up the screenshots of the UI once I am done with it (Hopefully by 06/25/2008).

Hoping to receive your continuous support :D

This warning says that Datastage encountered a hex code which has no definition in the code page being used (ISO - 8859-1 in your case). If I were you, I would find out the hex codes not defined in this code page (Search wikipedia for ISO-8859-1) and search for them in my source and then find the so...

Create a table definition with the columns for which you want to create a schema file(Or import it from oracle). Open the layout tab in the table definition and click on the "parallel" radio button. This will give you the schema of that table definition. You can copy this and put in a text...

samad, DSXchange is a site run by volunteers for free. And people here make sure that they do *not* answer urgent questions. I see that this is your first post, Welcome to DSXchange :D But don't put any "urgent" requests in the future. Have you pasted the exact query used in the job? 'caus...

You can declare a stage variable in a transformer after your sort stage which can be used as a counter. Input=====>sort===============>Transformer=========>output (create key change (Use the stageVar given on state) below to generate counts) counterVariable==> if not(ip.keyChange) then (counterVaria...

Search the forum, this has been discussed many times, You can use a function called GetEnvironment() (if I remember correctly) to get the values of environment variables in a Transformer.

Hi all, I have started working on an open source tool which would make a few things easier for the datastage developer. Some of the things which I am planning to incorporate in this utility: Creation of job reports Schedule of backups Launching of datastage client components I am going to document e...

I change to sequential, but obtain the same result. The sql query is select 1 as ind, seq.nextvl from dual; I use the ind = 1, to match with the lookup records. You can't drag and drop the key in the lookup stage when you are using a Sparse lookup. So something is wrong with your job. Now All you h...

What is the query with which you are retrieving this nextval?

select seq.nextval from dual?

Hijacking threads is not encouraged in DSXchange. Please post your questions in a new post. Now for your problem, In your sequential file stage, can change the read property to "File Pattern" and then in the "File Pattern" property you can give your file pattern and then read all...

Have you added the DSN in your datasources. You can check that in:

start==>control panel==>administrative tools ==>Data sources