DSXchange

I paid for premium membership over 2 weeks ago for account PeteM2, but my account has still not been updated to reflect this.

I have sent emails to the webmaster and the other recipients on the contact list but get no reply.

I would really appreciate someone trying to help me out with this issue

I paid for my premium membership renewal 7 days ago but my profile has not been updated.

I have sent numerous emails to the membership master and forum masters but no reply (not even a read receipt).

Therefore, I have raised here as a last resort.

Account username = PeteM2

Hi, I am trying to pull the FLOAT column from my source (SQL SERVER) through DRS/ODBC connector. Value in source is '7.59999990463257'. But once I extract this value into dataset through datastage extraction job, I am able to see '7.6' if I use 'double' datatype. Busiess wants the complete value fro...

Our datastage environment sits on a unix server and we are on version 9.1.2 now.
We have a requirement wherein we have to read a few excel sheets located on a Windows folder and load the data into oracle tables.
Was trying to find out if this is achievable and the best possible way to do it.

Thanks.

what is the best way to backup a 9.1.2 installation in order to perform a fast restore? I am aware of two methods, use the recovery tool or manual backup. The IBM documentation implies that the recovery tool requires a full re-install of infosphere information server. This re-install sounds like it ...

if we import around 1000 job into a newly created Datastage project while the production batch is running the jobs in existing datastage projects in the same server, will it impact the batch ?

We have a job that loads an Oracle table with two CLOB columns. The CLOB columns have been assigned LongVarchar datatype in the job. The Oracle connector stage uses run-time generated SQL and is set to load using the "Insert Then Update" mode. This job runs fine on the first run when the t...

We are trying to process an XML file using XML stage in Datastage 9.1 installed on UNIX server. We were able to successfully parse a sample xml file with the xsd that was provided along with that. We would like to know if there will be any validations performed with the input XML against the importe...

What is the maximum file size that the Folder stage can process in the server job? Our application runs on Unix AIX 7.1 and we use Datastage version 9.1. One of the posts dating back to 2006 says that it varies with respect to OS and datastage version. Is this documented anywhere now? Our intention ...

Thanks Ernie. The server job with folder stage worked just fine. Would just like to add one point here - When the default column definition is loaded for the folder stage from the built in definitions, the length of the "Record" column would be set to 999999. The output on the CLOB column ...

Hi, One of our requirement is to read an xml file located in a given path on unix and store the entire content of the xml file onto one column and a single record in an Oracle table. This table would comprise of 2 columns - filename(varchar) and xml content(xml type or clob). We do not want to parse...

I tried to replace all non pritable characters and spl characters to a blank space. I used the below code and still getting warnings: Convert(Convert("1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz","",Field name),"",Field name) Warning msg: BCI NLS inpu...

Mine is a simple job. Job type: Server Source: Sql server table stage Datatype: Varchar - Length 4000 In the transfromer - I am using the custom defined funtion to handle nonprintable characters and replacing with spaces. Also trying to using Convert function to convert spl characters to space but n...

Hi Craig, Thanks for your response. Well, the field which I read is a field where the user enters free text. So any type of text is expected. Even non printable characters are also expected in that filed. I have a custom function in the job to handle that non printable characters as well. I would be...

Hi, In my server job the source table is a Sql server table and one of the column contains Special characters (Var Char field). To handle the special characters am using the Convert() function to transform those special characters to spaces. Though few special characters are getting transformed by t...