DSXchange

Hi Krish,

Thanks for you tips. When I imported the structure for this table, it came as LongVarChar but with out limit. When I put the structure for the Oracle9i stage. It gives me a error. I think 7.5 is good to handle this. Let me check with our vendor for this new version.

Thanks,

Hi ecclesr,

If you like my idea please do as follow:

First create the batch file in a specific directory. Then create a sequential Job in that use the Execute command stage. Then call this Job in the Server Job so the next job will not start till this job completes.

Actually, I changed the column to Varchar with size of 2000 and I tried to transfer the data by concatenate the set of data. But I need the beter way for handling this. If any done please share your ideas.

Hi Pxlearn, It is not a problem. Go to sequential file properties. Select "NLS tab page" in that Select "Allow per column level mapping". Then for the job default you use the same as mentioned. But for that arabic column alone, change "ISO8859-6" in the column propertie...

Dear Gurus,
I am trying to transfer a set of data to one column in oracle with the data type blob. When I define as a longvarchar I am getting oracle error message. So any one can help me how to handle this BLOB Data type.

Our Current version is 7.1

Thanks with Regards,

Thiruma Valavan

Hi Gurus,
I am looking for the EBCDIC 297 Code page. How to get it? Is it is available in any site so that I can download it. If yes, let me know how to add it also. Please help me if any one done this before.

Thanks,

Thanks Tonystark. I edited the DSX File and changed the code page from 1252 to 1256 and imported it. It's working fine.

Thanks to all.

Regards,

Thanks C.Hulett. Here error message appears as follows: " File L:\Jihad\DSExportcustquery.dsx can only be imported when the client code page is 1252 - it is currently 1256 File L:\Jihad\DSExportcustquery.dsx does not appear to be a valid DataStage export file or is from an incompatible release....

Gurus,
We have DataStage 6.0 and DataStage 7.1 in different server. I want one job to be moved to the new version 7.1. So I exported the job from the old version 6.1 and while importing to 7.1. I am getting NLS Code page error. If any one did it already can you advice me.

Thanks with Regards,

Thanks Ray. I tried by sending .html file as follows: "D:\Ascential\DataStage\Engine\bin\dssmtpmail.exe -server 10.10.1.1 -from TValavan@AA.com.sa -subject "ETL - Test Mail" -message d:\Ascential\DataStage\Projects\DAILY_DEV\fortest1.htm TValavan@AA.com.sa " But before this bat f...

Highlight me "BOLD". I tried with char(2) but, it gives me some junk character. Thanks for your comments "chulett". I am waiting for GURUS who had done this. Thanks in advance.

Regards,

Gurus, I need tips. When I send mail in the body of the message I want to Highlight the word as heading and the message as normal text format. I want to know is it possible. Here is my script: pmSendTo = "TV@aaa.com"; pmSubject = "ETL - IGNORE - Test Mail"; XFrom = "From:TV@...

It's working now. Thanks for your gideline.

Thanks with Regards,

Hello Gurus,
I am having a problem. I am getting a file with UNICODE Format. I need to convert to the normal format. Actually, the file is containing "Arabic data" I need to convert it into normal file (i.e. MS1256). Please help me to solve it.

Thanks

Here is the another solution if you create the server job.

If you use the DataStage Seq File control in the File Path area you can specify like this “C:\Test\File_NAME#BUSDATE#.TXT”

Where BUSDATE is a Job Parameter with type String.

Regards,
Thiruma Valavan