DSXchange

Explain more on the validation you are doing. In fixed width length record the size is always same. If you said 4 columns of fixed width type and each of length 100 then all the rows will have 400 characters length whether you have data or not. You have spaces if there is no data.

Thanks
Siva

First check your DSN in the odbc connectivity from the control panel. If you had configured properly there then you will be able to import the meta data in Datastage using ODBC.

Thanks
Siva

The right conversion will be OConv(Arg1,"MC/A") .

If your Arg1 = HS2002156817161-1 then the result = 2002156817161-1

Thanks
Siva

Remember MCN only picks up the Numbers(0 to 9) not the (-).

Siva

In version 7 you have Row Splitter and Row Merger. The splitter reads one row and splits a string into number of columns. The Row Merger merges all the columns to one single string in specified format. As Keith said you can use Pivot to convert columns to rows. and Row Splitter to convert rows to co...

Try to bring in the DateTime filed as String and while writing it to the target convert it to the right format.

Rasi

Yes this can be easily done in datastage. Use stage variables to hold the sub-total and sort the record before sending it to the transformation so that whenever the field-A changes you can display the total and reset the subtotal. Also declare a separate stage variable for Grand Total.

Thanks
Siva

Hi The answer to your question is "YES" it does improve the performance if you reduce the number of columns in your hash file. Normally while creating the hash file(Lookup) you need to use only the columns which you will be using in your jobs. Don't load unnecessary columns which takes up ...

Hi With the Stage Variable it should work. I think you are having a logic mistake in that job. Inside your transformation for assiging stage variable then you should see that its value are correct. From the input file pick up the correct header record and pass it to the stage variable. (ie. If recor...

You can't change the metadata dynamically and execute multiple times with different parameter. The best thing is to create sql files and call from datastage by passing parameters

Siva

The Link collector stage support upto to 64 inputs. So reducing from 7 to 3 is not the problem. The stage also has the constraint that both the meta data for input and output links must be same. Check the metadata on your inputs and output.

Thanks
Siva

The column name doesn't matter whether it is same or not. But give a meaningful name so that it is easy when you are doing your mapping. How fixed width works is by the position. You have to give the correct length otherwise it will end up in some other column. Even if you miss one position your map...

The error says Access Denied. The only reason is you don't have permission to access that file. If the file is missing then it would have said Unable to open the file.

Thanks
Rasi

Check the user permission on the file. If you ran the job with a different user and then try to read from another user it will give this error. First thing is to check the permission.

Thanks
Siva

Row Splitter works same like the sequential stage expect it reads the data from a link. This is to split a input column into multiple columns. For example if you have a column say reject_column which holds all the information into one single string then this string can be splitted into multiple colu...