DSXchange

Thanks for the suggestion guys but the error seems to be something else. No the error is not system specific. I tried it from two different systems. Its gives the same error in both. I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns ...

Hi All, When I try importing a table from DataStage Manager using Import\TableDefinition\ODBCTableDefinition I get the following error message for certain set of tables: "Run-time error '6': Overflow" Though the import works perfectly fine with some tables. I am not able to figure out why ...

We are setting up the Ascential server. We have configured 3 NT groups: Ascential Designers Ascential Administrators Ascential Operators Within Ascential we have assigned each one of this 3 groups to the corresponding Ascential roles. We have the following security issue: only local administrators c...

Great Vincent. I could never before figure out what "incomplete columns" meant.

Regards,
Sumit

One way is read the entire record in one column and validate the total length of the record. Then you can 1) Either use Substrings to break these one column records into multiple columns. 2) Or put the records with valid record length into another sequential file and then read this file as fixed len...

I totally agree with Kenneth Bland. If you have intense transformations then using multiple transformers prevents overloading of one transformer. By splitting the load across transformers you actually do a load balancing. This definitly gives a better performance if you use row buffering. However fo...

Yaa, link collector is also an option but make sure you set Inter Process Row buffering in the job properties.

-Sumit

ok. Then you probably can try this. Pass all the records through a pivot stage and break them into two records. One with the original type and one with type value hardcoded to 'vehicle'. Also add a dummy column in the pivot stage say DUMMY that would store values '1' and '2'. Input records to Pivot ...

One way could be:

Using a constraint route all "non-vehicle" type records through a pivot stage where you can break each record into two. One with the original type (say 'Truck') and the other one with type hardcoded to 'vehicle'.

Regards,
Sumit

Oh yes the code actually is not required. We can also use ConvertMonth with option "L". I should have checked the link sent by you first before posting the code. Well, since I have already posted the code it might give him an idea of the logic used in ConvertMonth routine. Thanks Chulett S...

Sorry there is a little error in the previous code I sent. Here is the code to get number of days in a month: The input date should be in YYYY-MM-DD format. You can write a routine (Transform Function) with one input argument called date1. y1 = date1[1,4] m1 = date1[6,2] d1 = date1[9,2] InYearDate1 ...

Say you get an input date and you have to get the number of days in the month. Say the input date is m/d/y Follow the following steps: 1) Add one month to the date (m+1). 2) Hard code the date to 1. So your new date becomes (m+1)/1/y 3) Now substract one day from this new date. You will get last dat...

"DataStage Job 35" means that your Job code is 35. In your system that holds DS server go into RT_BP35 folder (It will be in Ascential\DataStage\Projects|<ProjectName>\). There you would find files for active stages in your job. Open those files and check the line number 14. Try to find ou...

The command to create an entry in VOC file.

SETFILE <pathname_of_hashed_file> <hashed_file_name> OVERWRITE

Example:

SETFILE /usr/CUST CUST OVERWRITING

Hope this helps.

Regards
-Sumit

Thanks Wurlod.

-Sumit