DSXchange

Hi
We did the same thing, i.e. installed Datastage without installing the NLS pack. What we did is put the installation CD again and start the repair option and just select the NLS option this time.
the only difference is we have Windows.
IHTH
gradkarthik

Hi, you need to convert the timestamp format to the date format using ICONV and OCONV function before you can load them in to either DB2Unix. I am not sure what the format is for OS390 but what ever it is, the conversion has to be done in a transformer stage before loading. Look in the BASIC Manual ...

My Bad..
I didnt see the version 4x

Hi You can write a subroutine to check the status of the job after the job has completed (DSGetJobInfo) and then depending on the status you can then use the DSSendMailTask to send you an email informing you ASAP if the job has failed or succeeded. (Refer to BASIC Manual). You can run this subroutin...

Hi

I dont think it validates the columns because I just entered "abc" in the Table name(s) field and still the job ran without any problem. Its probably uses the value in that field to allocate buffer memory or its just the way MSOLEDB was supposed to work.

gradkarthik

Hi guys, I solved the problem. I had unknowingly left the field where you specify the table names in MSOLEDB stage blank. I was using a user defined sql query but the MSOLEDB stage still requires something to be present in the table name(s) field for the job to run successfully. Its wierd because i ...

Hi ArndW,
Thanks for you reply. I have other jobs which have MSOLEDB stages in them and they run fine. Its just this new job that i am developing that is failing.
gradkarthik

Hi guys, I checked the user id and password and tried running the job by hardcoding the values rather than using parameters. It still failed. The funny part is when I replace the MSOLEDB stage with the ODBC stage, the job runs fine without a hitch. So can rule out the incorrect user name or password...

Hi, One of my jobs which reads data from a sql server table and writes to a flat file is aborting. I am using MSOLEDB stage to read the data. The error given in the log file is DataStage Job 1372 Phantom 2524 Program "DSP.Open": Line 122, Exception raised in GCI subroutine: Access violatio...

Hi Ray, I didnt understand what the MAXFETCHBUFF and maximum number of columns (MAXFETCHCOLS) have to do with the rounding of data in a particular column. My main question now is how DS rounds off data by just specifying say, Decimal(2,1) on the output side in transformer stage for a particular col,...

Hi to all, thanks ArndW and KcBland for the suggestions. I was playing around with the job when i observed that if i ran the same job with just specifying decimal(2,1) on the output link and output the result to a flat file then without using oconv or fmt in the transformer, the value gets rounded o...

Hi I have some doubts about the working of parameter markers. in one of my jobs i have a col with values like 0.69999999 which i want to round off to 0.7 and output to a sql server table. I do this in the transformer by specifying the datatype for that col on output side as decimal (2,1). the value ...

Hi everyone, I am using SQL server database. Ideally the SQL server database should return an error msg when a create table statement is encountered without a drop table statement first when the table is already existing in the database. The job runs without any error. I think there is probably some...

Hi I checked the log of the job but no warnings of any kind. FLATFILE_TO_SQL..ODBC1: Using project default NLS map MS1252 FLATFILE_TO_SQL..ODBC1: DSD.BCIConnect call to SQLConnect returned informational message. As you can see, no kind of any warnings of any kind. One would expect a error msg to be ...

Hello I have a job which just loads data from a sequential file to a SQL Server table and i use and ODBC stage to accomplish this. however i have create table enabled and drop table disabled. that means if the table already exists in the database then the ODBC stage should essentially give an error ...