DSXchange

no there isn't so I am using DRS....and it is partly working....

but do I have that option in ODBC stage.??

well I almost went through whole dsxchange...got a similar kind of problem...in http://www.dsxchange.com/viewtopic.php?t=91340&highlight= I have a longvarchar field len 2147483647. I changed this to longvarchar 2000 and then when I tried to view data it says: [DataDirect][ODBC SQL Server Driver]...

SET IDENTITY_INSERT User ON;

INSERT INTO User(UserId, UserName, UserAccessType, UserRoleId) VALUES (?,?,?,?);

SET IDENTITY_INSERT User OFF;

I feel it is some connection problem. When I try with ODBC(target) stage I can view data with condition: insert row without clearing. but with condition:user-defined sql, the view data tab gets disabled. And with DRS stage, when I do view data it says: DSP.Open GCI $DSP.Open error-100 Have u ever fa...

I got while doing a simple insert into a table....

regards,
Arnie

Hi, I am getting this error: [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]The DataDirect ODBC driver you are attempting to access has been provided to you by IBM Corporation for exclusive use with IBM Information Server. You are not licensed to use this driver with any applicatio...

By template I mean the place where we create the jobs. Imagine I have 2 independent jobs in that(2 jobs in 1 background). But I want to run only 1 and not the other. Is it possible??

Regards,
Arnab.

HI,

Is it possible to run only selected jobs under 1 template.

Regards,
Arnie.

Hi,

I am getting an error:
SQL data type '%1' defined on column %2 is not supported.

Have never seen this before. Please suggest.

Regards,
Arnie

Yes sir,

looks like it has to do with space because I am unable to create copy of existing jobs.

Regards,
Arnie.

Hi ,

I am getting the below error:

Transform_USA1_TGT_Component_test..Sort_MachinerySeqNum: Error in merging files
File '/apps/ascential/Ascential/DataStage/Projects/Shell_LubesAnalyst/soxe3UDr/opf__3' write error


I am unable to figure out the problem.Please help.


Regards,
Arnie.

yes....values are becoming NULL...so I am getting the error..

Hi,

In a simple one to one load job where I am loading from sequential file to DB, the records are getting NULL and I am getting error:

SQL Server]Violation of PRIMARY KEY constraint
Cannot insert duplicate key in object

Help please.

Regards,
Arnab.

Yes...I created the hash file.....it is reusable job...only this time it is failing....with new set of data......