DSXchange

Hi

There is a separate forum(Looking for Talent) to post these job opportunity.

Thanks
Siva

I am not sure whether you have rownumber features in SQL Server. Two things you can do to get the work done. You can use SET ROWCOUNT 10000 and then use the user define sql. Another way is to use the Director to limit the number of records. When you run the job from director in the limit type the nu...

Thanks for that reply. It helped me puting this in the metadata dictonary rules for processing copy book formats.


Thanks
Siva

Consider putting this into a reference table and use it as a hash lookup. This is maintenance free solution. Also not hard coded in your job. Anytime you need to add or change in the reference table. Worth considering it.

Thanks
Siva

There isn't any limitation in sorting. But it does take long time in sort stage. You can use unix sort which is better without buying any third party sort software (ie cosort etc.). Consider putting the records into a staging table and use your database to do the sort. Much faster with adding proper...

I had got answers for PIC 9(6)9 and PIC 9(1)9. This is a strange type of definitions which means PIC 9(7) and PIC 9(2). These definitions are still valid.

Thanks
Siva

Open your director for the aborted job. Use the reset button in the menu. This will give bring more logs to your director. Read those information and post it. We can help you.

Thanks
Rasi

I am having problem in reading the format of the copy book. I had received extracted file based on the copy book and it is fixed width file. Following are the sample of format which I can see in the copy book. First I need to know what will its length in fixed file and second I need to convert this ...

Hi

First your question is not clear enough to answer. Make sure people who reads understand what you want. This will help them to help you.

Extract first 12 character and use Iconv will be like ....

Iconv(InputCol[1,12],"D-YMD[4,2,2]")

Try this

Thanks
Siva

Hi MCN will never put dashes in its output. It only extracts the numbers which from 0 to 9. The reason why you are getting the dashes is your target data element is defined as date data type. Change the data type to Character and run the job it should work. If you have your target as date date type ...

Hi

You can change your target to hash file and make you unique columns as key. This will overwrite your duplicate rows and you will always have unique rows.

Thanks
Siva

Could anyone let me know what is DRS(Dynamic RDBMS stage). I am using Version 7.0.1 and haven't seen any stages like this.

Thanks
Rasi

Hi Raja View the datastage help about Row Merger. Below is the first few lines extract from the help. The Purpose : "The row merger stage reads data one row at a time from an input link. It merges all the columns into a single string of a specified format. It then writes the string on a given c...

Get all the keys from your existing job which has the foreign key constraint. Then create a job which passes these keys to those table to delete records from parent table first. After this job is finished use your Clear table/insert logic. It will work

Thanks
Siva

Hi

Look for this url http://www.anotheritco.com

it has some datastage White Papers.

Thanks
Siva