DSXchange

chitravallivenkat wrote:Ray,

This works when a job has only two links. If we include more than 2, it aborts after few minutes which means after reading hundred thousands of rows.

Regards,
Venkat

It does not throw the error in all the links. it throws any one of the links.

Ray,

This works when a job has only two links. If we include more than 2, it aborts after few minutes which means after reading hundred thousands of rows.

Regards,
Venkat

Hi Jack, If there are more than 2 links, it aborts by throwing the following warning messages GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1: Failed to read the row. GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1: OLE DB provider error HRESULT=0x80004005. Attempting to Cleanup after ...

Thanks Jack. I will test the job by breaking the link one by one. I hope this will help to help to find out the problem to some extent.

Regards,
Venkat

In addition to the above message..,

The job is extracting the data from SQL database and inserting into Hash file for lookup.

Regards,
Venkat

Hi, Lookup Job is aboring by the fatal error " GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1: |-100|". Structure of the job: The job has only one OLEDB stage and one Hash file stage with 15 links. Out of 15 links, 9 links connecting to same table by different queries. Other links ...

thanks Chu... & other guys.

Regards,

Hi Guys,

From SQL server side, it is clear. We use the default which is 1433. I wanted to know the port in Datastage side.

Because there is a firewall between Datastage server and Database server.

thanks.

Hi,

Could any one advice How to find the Datastage port used to communicate to SQL server?

thanks,
Venkat

Thanks for reply....Any idea about where can be created?

Hi,

Datastage 7.5X2 is installed in server machine. now i want to connect the client machines to server. But i dont know where can i create user id and password for client users.

Please advise how to do that.

thanks in advance.

Venkat

we have users who use domain accounts. these users could use Datastage Client such as Datastage Administrator, Desinger without porblem. However after we changed the server's ip and server name, these users can not launch Datastage Administrator any more. Any body could help please?

Thanks,
Venkat

Get the value in variable and seperate the value from the variable using sequence number and delimiter used in the value.

Thanks...I got it....

Hi,

I have one question about environment setup in the DS server.

Can we setup different environemt like for Development, QA,etc.. in same Datastage server?

Thanks in advance,
Venkat