DSXchange

Index and Convert as proposed worked just fine.

When you are dealing with Packed Decimals, unload the file as complete one column (maximum length of the row) in first step. Don't do anything in this step. Just unload the file on your UNIX server. You can either unload via ftp script or use ftp plugin, use 'BINARY' as transfer mode. Once you unloa...

Even if I plan to use search function (INDEX) 10 times, how to I search for numbers 0-9 in a string. Can this be done in 1 function?

I have a string VARCHAR[10]. Here is what is needed (1) First find out if a string has any numeric digits or not. (2) If yes, find the first position of the numeric digit. (3) Also, find what that numeric digit is. I can find out if a string has numeric or not using Alpha() but for those string that...

We are on 7.5 and will be migrating to 8.5 in 6 months. Is there a place from where I can get all documentation for 8.5?

All help appreciated.

you may want to do a search on this environment variable: APT_DECIMAL_INTERM_ROUND_MODE APT_DECIMAL_INTERM_ROUND_MODE Specifies the default rounding mode for any decimal intermediate variables required in calculations. The default is round_inf. Here is what I did that seems to solve the issue. (1) ...

I have a source data file (dataset) that has a column defined as varchar(17). The column contains decimal values (11 places after decimal). Example: 0.28765498765 1.98198765200 1936.27000000000 I want to sum up column values but without any rounding. Example below.... Example: A 1936.27000000000 143...

Hello, How to I change multiple rows into 1 column having all the values of multiple rows into 1 column separated by comma. DATA IN PRESENT FORMAT CD_P CD_B CD_S ACT MYYYY SLS_IDS 2U2Z 2V001 YA 38 12009 92 2U2Z 2V001 YA 38 12009 93 2U2Z 2V001 YA 38 12009 99 2U2Z 2V001 YA 38 12009 102 2UKK 2V099 MN 4...

Shamshad,

Thanks for great input. We just removed the password file and recreated the file and there you go....Jobs in production ran exactly as in QA.

Thank You All once again.

Ok here is what I have found so far. The job works fine in DEV/TEST environment. Encrypted DB2 password is passed from Master Sequence to Another Sequence and then to JOB and it works fine. It's only in PROD that we have issues with the password parameter. I debugged it further and changed password ...

My DataStage Job works fine when I read from an DB2 source and having the password hardcoded. When I call the same job via a sequence and passing password through the sequencer the same JOB ABORTS. Eample: I defined a parameter in Sequence called db2password. I also defined the same parameter in my ...

I have almost 80 Datastage Jobs and 50 Datastag Master Sequence. I have to create the design document for each and every job and sequence. Manually I can open each of these jobs/sequence and 'generate report' through designe but that would be time consuming. Is there a way I can generate the design ...

We have DataStage 7.5.2 in production and want to upgrade to version 8.0. Here is how we handle mainframe flat files in 7.5.2 using 2 jobs where we have to convert any EBCDIC characters into ASCII equivalent. (1) Job 1 : FTP plugin > TRN>Sequential File (FTP type is binary) (2) Job 2 : CFF Stage > A...

Reading a mainframe binary file using a CFF stage and simply dumping 5 million rows to a teradata table using Enterprise Stage. Takes anywhere 35-40 minutes to load. No transformation is happening. (1) Any way to reduce the load time? (2) Is Enterprise Stage the best way to load 5 mil rows in terada...

In our project we have been running 35 Master Sequence daily which calls about 80 different jobs. We stored only 4 run logs in the director. How can I get run information for all master sequence and jobs for past 30 days from current date from the Data Stage Server? Is there any graphical representa...