DSXchange

Interesting... We never had 7.5.1. We started with 8.0 and are currently on 8.1. We still have windows opening up off-screen on occasion. I would think the patch would have been included with later versions.

Your Execute Command Stage window may be opening up off-screen. We have had this happen several times with different stages. The next time DataStage "Locks up" try pressing Alt-Tab to see the list of open applications. If you see an unknown window, select it and then move it back onto your...

Thank you Craig, I tried the below but it still isn't identifying that character and replacing it with the space:
if IsNull(DSLink5.DESCRIPTION) then Space(1) else Convert(Char(92):Char(2019):Char(10):Char(11):Char(13),' ',DSLink5.DESCRIPTION)

What are the impacts of changing the dsadm Password?

I got a workaround I am using replace function while extracting from DB2 and it works.

yes Craig

Thanks Ray I tried that but its not working.I used isnotnull(field1) and isnull(field1) but still its not working and all the records are going into the not null link as unknown characters are occupied in that length of 5.And more over trim would also not work as they are unknown characters from dat...

I am trying to trim a field whose datatype is char(5) in db2 database.I am setting APT_STRING_PADCHAR to "0*20".In the transformer I am trying to capture all non-nulls into 1 link and null values link into another by using proper constraint condition Len(trim(field1))=0 but everything is g...

I got the answer by myself usually for unicode the length has to be double.

I am trying to load the data "XO" into a sap idoc segment field whose datatype is varchar(2) but its failing with the following error message. "IDoc_Load_ZAFSMATMAS01,0: Fatal Error: Fatal: IDOC_F_00145`:`Segment 'Z2BP_MARCX000', Field 'MRP_TYPE', Value 'ND': CIDocData operator=(char)...

Thanks for replying.

Can you please explain how to use this command?

Hi For a Bapi Stage the INput file should be saved in Unicode Big Endian format. I have a table from where I am collecting the invoices numbers which are doing to my INput file used in the Bapi Stage to extract the data. How can I save the file in the Big Endian format in the Seq file stage? I tried...

Thanks for your response.The target field datatype is decimal with precision of 5 and scale of 4.The Source field is varchar with length of 20.The function being used in transformer is string to decimal type conversion function before loading into DB2 table.The DB2 database is a unicode database.So ...

I have a job which reads data from Dataset and writes to a DB2 Mainframe database tanle using DB2 API stage.The job runs sucessfully but doesn't post a single record.It gives the following error message "DB_Load_MM_COLL,0: Warning: Material_Extract_MM_COLL_Stg_Load.DB_Load_MM_COLL: [IBM][CLI Dr...

I have a requirement where I need to read japanese data from .doc fie and write it into DB2 database table.DataStage and DB2 database are both NLS installations.The NLS_LANG which is being set on operating system is EN_US but operating system also has unicode locales being installed.Now I am reading...