DSXchange

Sure, DS ships with an ODBC driver to SQL-Server 7. You just configure the odbc.ini file with the entries to point to each SQL-Server. It will require things like IP or hostname, db name, port, etc. No problems doing what you want, as long as you have the right version and configuration information...

If my DataStage Server is on Unix Box,

is there a way DataStage can communicate with SQLServer Database.


Is it necessary to have the DataStage Server on Windows(only),
if we are loading data into SQLServer database?

Thanks in Advance.

We faced this problem.

If you have Microsoft Service Pack 2 installed , you will not be able to open the jobactivity in Sequencer jobs.

Try uninstalling service pack 2 and check, it will definitely work.


Thanks

Thanks for all the ideas. I want to mention here the things we are doing & not doing. We are writting all the intermediate files in seperate directory other than ProjectDirectory. We are not creating the hashfiles outside the UV. Is there a way we can delete the hash files that are created tempo...

Hi, Our Project Directory RootDir\Ascentail\DataStage\Projects\DEV is growing too big. The reasons we think may be due to temporary files/intermediate files created during the project. Can anybody guide us to what are the Folders( or fiels in that folder)we can safely delete, that may be of no use a...

How can I represent a multi-valued column?
Array of values in a single field.
Basically can i decalre an Array kind of thing?

Thanks in Advance.

Roy,
Sorry to ask this,
where can i find that.

Thanks & Regards

roy wrote:Hi,
I wrote a FAQ example that might be used to concatenate all this info into 1 write operation.

look it up.

IHTH,

I have a scenario like this: Field1,Field2,Field3,Field4,Field5,Field6...................Field150. Here I have to validate each and every field against some Business Logic. If Field1 is not numeric write out to error table and if Field2 is not numeric write out to error table and so on. In worst cas...

We are on 7.1

We are getting lot of problems.

Sometimes we get OLE Error.

We really don't know why these Errors are popedup and crashes the Designer.

Thanks

Thanks Roy.

Nothing has been changed recently. We haven't done any of installations.

As you said, yes,
its hapenning mostly when working with Aggregator and Pivot Stages.

We opened up a support case, haven't heard anything yet from Ascentail.

Hi, When we working with DataStage Designer, we were popedup with the following messages in sequence: ---------------------- DataStage Repository Interface (Message Header on the Message Box) Run-time error '91': Object variable or With block variable not set --------------------------- vmdsstge (Me...

Hi Craig Hulett ,
Its literally a new line getting generated.
AnyHave thanks for your time.

Hi, We are working on a Migration Project (MainFrame to SQLServer). Initially the source files are manually FTPed from MainFrame to DataStage Server(On Windows). We use that source files and transform the data. Here my question is, when a file is FTPed from MainFrame, a new line is generated at the ...

We are doing the things way more than that , using DataStage.

I think you can proceed further, to use DataStage for your purpose,

provided you have good Developers in DataStage.

(who has good command over HashFiles and Basic)

Hi, I am trying to insert date values into db2 table which is defined as date(10). I tried using both ODBC & DB2UDB stage. When i use ODBC stage, iam getting the following error: Illegal date/time value DATE1 = '01/01/2004' When i use DB2UDB stage, iam getting the following error: " Value t...