DSXchange

Hi Ray,

That's exactly what I do and it works fine for the source_seq. I now want to send the same userstatus to the master_seq. How do I do that?

JCL is a job control in basic.

Thanks.

Faeez

Hi, I have a master_seq which call an underlying source_seq which in turn calls a piece of JCL code which executes a command line to source data. The JCL job sets the user status to one of 3: success, failed, nothingnew(if now new files were generated for a certain time period). In the source_seq jo...

Hi, I hope someone out there knows what the following error means: main_program: Fatal Error: Non-positive length [persistence\archive.C:2427] We get this error when we load 4 -12 million records into a table. It loads up to a certain point everytime and aborts with the above error. More or less on ...

Tx guys.

Will try it out....

Ciao.

THis is what i need to do: I need to select data between variable date ranges. MY select statement looks like this: select * from table where timestamp between #StartDate# and #EndDate#; I have non-DataStage users that get a unix script that they execute. The script includes the dsjob -run -param. S...

Hi,

I need to use the dsjob -run -param to pass parameters to a DataStage job but the parameter values need to be prompts. How do i do this from the unix command line.

Tx.

Faeez

Ive tried that but it does not work. One of the source systems changed from SQL Server 7 to SQL Server 2000. My ODBC connection to SQL Server 7 works fine. My .odbc.ini for SQL Server 7 looks like this: [empower] Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so ...

Where in the following do i insert it:
[empower]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Address=empower,1433
AnsiNPW=No
Database=PWA
LogonID=sa
Password=
QuotedId=No

Tx.

Faeez

Hi Larry,

Did u manage to resolve this issue.

Thanks.

Faeez

Hi, I am running DataStage 7.5 on a Solaris 2.8 platform. ONe of the source systems changed from SQL Server 7 to SQL Server 2000. My ODBC connection to SQL Server 7 and everything else works fine. My .odbc.ini for SQL Server 7 looks like this: [empower] Driver=/export/home/dsadm/Ascential/DataStage/...

Hi,

Did u solve this issue.

Faeez

This is what my dsenv looks like. It worked fine in DS6. ####################################################################### # # DataStage Server Runtime # # Module dsenv # # (c) Copyright 2000 Informix Corporation. - All Rights Reserved # This is unpublished proprietary source code of Informix ...

Hi LUK

I have tried it using dssh and it connects fine. Some times it works in DS and some times it does not.

Thanx.

Faeez

Hi there, We have just upgraded from DS6 to DS7.5 and are experiencing the following problem: I am getting the following errors when using an ODBC stage in DataStage 7.5 trying to connect to IQ: Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project PH2_DWH_P...

Thanx guys.

Faeez :D