DSXchange

If you don't specify trim option and which character you want to remove then DS will perform a Trim on leading trailing spaces and tabs. http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.serverjob.dev.doc%2Ftopics%2Fr_dsvjbref_Trim_Function.html Also, if...

If you enable RCP in the shared container you should be able to input metadata that does not exist within the SC metadata definitions

Bonus info: the timestamp columns are nullable It seems that when a NULL is present in one of the timestamps columns then the "sql code" reject link crashes. My workaround so far is to give a default value in a transformer before the ODBC connector and the use a after SQL to update the rec...

Hi - On my database table I have a unique key, and when I write to the table I want to catch the records which fails to be inserted due to a key violation with a reject link from the ODBC connector. However when records are rejected the job fails with the following error: [IIS-CONN-DAAPI-000045] Can...

Do a join on the tables. Ensure the data is sorted on name and id before passing into a transformer. Create stage variables in a transformer: - svNameIdSum (summarizing the value1 on name/id level) - svIdSum (summarizing the value on id level) - svTargetValue (the target value e.g. 100) Set the cont...

well... my assumption were that you had your history availiable in your EDW and that it was only a dimension table in a DM you were trying to populate.

If you want to test if a value is purely alphabetical you can use Alpha() - it will return 1 if true

How big is your dimension table? - consider if not a full reload is faster and easier.

Hi -

Have anyone found a way of mapping the basic authentication from DS to the Windows authentication?

I'm having the same problem with calling a Sharepoint webservice which requires my userid to be windows authenticated (Kerberos)

Our DS installation is on Linux.

Thanks

Is it only in the first line where you have the column names /header that you have a space delimiter?

The problem you have is described in a technote from IBM: Failed to load JVM into the DataStage Server process (dsapi_slave) 8.0.x message: "(The connection is broken (81002))" 8.1 and later message: "CDSRUserAccess.EnterCS: Internal error - Failed to open file : UV.ACCOUNT (81002)&qu...

As you said - the error can have many causes, however in my experience a 'Parallel job reports failure (code 139)' is usually caused by running the job with the wrong parameter values. So, since the the job is running fine in one environment and not in the other, then check that you have the correct...

True. You can actually tic that option off in the sequential file stage when going for the pattern method. And I think it will remove column names from the first file in the list. The way DS processes the files is NOT reading one file at a time, but instead concatinating all the files in one huge fi...

Put this in a stage variable and use the result to define the constraint.

If Index('___Joi|___Roi', to_transf._ID[1,6], 1) Then 1 Else 0

# and $ sign are reserved signs in DataStage, so maybe it is possible to use the internal representation of the signs in your select statement? http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r1/topic/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvrf_Column_Name_Conversion_odbc.html?resul...