DSXchange

Thanks Ray. It worked. I did not realize it was putting @FM at the end. I thought it was putting a Unix new line at the end.

Hello, I have to process a list of files in a loop in the sequence and I am running into an issue. First I get the list of files by doing a ls -m(Execute Command Activity) and then use the start loop activity to process the files thorugh the sequence of jobs one after the other. The issue is the las...

Thanks. The issue was I did not set the client character set to UTF8 during the load.

Hello, I have loaded a file with international characters from around the world in UTF-8 format using DataStage 8.0 parallel job into a Teradata Unicode table. When I export the table from BTEQ and open the file in Excel(Using UTF-8), I am able to display all the international characters. If I run a...

I imported the cobol copybook into IDA and it created a Logical model. I then created a physcial data model from the IDA and then used the DBM metabroker from the Import/Export Manager. I am now able to able to see the database names and schemas( I had not applied the filters correctly when exportin...

Hello, I imported a cobol copybook into the Infosphere Data Architect and created a physical data model out of it. Now I imported this model into the metadata repository using Import/Export manager and it finished successfully without any errors. Now I am unable to find the model in the metadata wor...

Hello, I get the following error when doing a check on my apt_config_file. We did a new installation and nodes are defined on the ETL as well as DB2 boxes. I am able to ssh to the different boxes from the server but when I try to test the config file I get the following error. ##I IIS-DSEE-TFCN-0000...

Hi I design a job to find out missing data. But i have find out Reject data that is why i am using Lookupstage. If you are using the Lookup stage just because you have to capture the reject rows, then you can do a left join in a Join stage and filter out the reject records in a transformer or Merge...

Check this post..

viewtopic.php?t=128561&highlight=

I think the value 501966000102 is beyond the maximum limit of the Integer data type. Can you use target as BigInt instead of Integer?

Yes. From Anbu's design.. --Define the column name(field 1) in the row generator as the same as what is defined in DB2. -- Open the properties for that column in the row generator stage. Click on Algorithm. Add values ('AAA'). Add the values again ('BBB'). -- Set the row generator to run only for 2 ...

-- Check if the DSHOME path is set in your .profile.

-- The comman is echo $DSHOME (You had mentioned $echo $DSHOME)

You have mentioned the lookup stage property is auto-partioned.

Instead, can you set the partioning in the reference link to Entire partioning. The input link be auto-partioned. Please review if you get the right results.

Replace your API stage with a Sequential file and write into it as a test. Open the file in Unix and check if the char column is padded with null character or something else.

Char type will be padded with spaces as Craig/ArndW have already mentioned.

If you need some additional convincing than what Ray already said.. I have been a premium member here for a while and have renewed it twice..

And NO.. no one stole my Credit card details...