DSXchange

Also please try to install VC++. I was facing the same problem before and installed VC++ and every thing was fine.

Is there any other function (like checksum) or logic to suffies this requirement?

Thanks chulett for your reply. This challenge has been resolved now.

Thanks chulett for your reply. This challenge has been resolved now.

Thanks Ray.I tried the String Function however it is not working.
I am not able to see your email completely.

Please let me know if there is any function / workaround for this.

Hi Can you please let me know which function in DataStage is like SUBSTR function in ORACLE? Requirement: Source and Target is Sequential File Input Data : 123456.1234578 Output Data: 456.12 Logic Cut String from 4th Character to 10th Character (including Decimal) Can you please let me know how can ...

Nullable status for all the fields is "No". Still I am facing the warning. "When checking operator: When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify ...

I used the code in the transformer. In the Column Derivation of XXXX column.


Thanks
Sameer

Thanks for your reply. However

I used following code for null handling.

1) If IsNull(XXXX) Then XXXX Else '000000000' : Warning is still there
2) If IsNull(XXXX) Then XXXX Else XXXX : Warning is still there.

Target is fixedwidth file.

Thanks
Sameer

I am populating sequential file from database using single transformations . While populating the XXXX field i am facing following warning.: [i]When checking operator: When binding output interface field "xxxx" to field "xxxx": Converting a nullable source to a non-nullable resul...

Hey Ray,

I appreciate your help. I used the second option and it is working without warnings.

Thanks and Regards
Sameer

Hi I am reading a COBOL File (Without Redefine and Occure Clauses) in a Sequential Stage. It is fixed with file having Record length 60. To Read this file I have mentioned Record Length in Record Level as 61. (if I mentioned 60 it throws error don't know why?). Job is running file but with the warni...

Hi Chulett, Thanks for your reply. My problem is resolved with the information that you have provided. Thanks a lot once again. Regards Sameer [quote="chulett"]Yes, the grants needed are [i]specific[/i] to the Oracle Enterprise stage because of how it operates. There are several "sys&...

Yeah as per the error message it is clear that I need "select" permission on the view. However I am confused because the same view (with the same login credentials) I can access from any other availabe stages for database.(Both Server and Parallel). I am facing this error only for ORACLE E...

This is the information available in Help file. Connection Category DB Options. Specify a user name and password for connecting to Oracle in the form: <user=<user>,password=<password>[,arraysize=<num_records>] DataStage does not encrypt the password when you use this method. Arraysize only applies t...