DSXchange

there comes one with DataStage. Look into:

* your manual
* your branded_odbc-directory

there you find all details for the test.

Wolfgang

This guide is as pdf-document on your cd, you got from Ascential.

Wolfgang

it is not easy to write the correct userdefined sql-code.

Please show us, what code you send via odbc and show us also how the genereated code for for example an update looks like.

Wolfgang

is the other project same server?
if not same DS-Version?

Wolfgang

Fabiano, follow the way Craig Hulett tells you and you can solve the problem. If you are more fit in UNIX shellscripting in connect with sqlplus you can, as we did in our company write a shell script using the dsjob-programm. By this you can write a nice programm to fill you table. So there are so m...

Hi Raj, the Aggregator is like his name tells us for aggregating. If you don't want to aggregate: don't use the aggregator!!! In a Datebase you cannot use the group by without telling to all fields in the output how they shall be delt. So don't blame DS and its Aggregator. Buy a SQL book and learn a...

don't blame AIX, it is a local pc problem. Check if mlist.ocx is present on your PC and the register it (HowTo: Look into your Windows Administration Handbook). Maybe you have installed the product without have administration mode set on your PC. Try to reinstall as Administrator after having uninst...

Hi raj, a 130+ stage- Job wow. My first smell, without having seen the job: do you need everything so complicate. DataStage is transforming all your grafical code into p-code and then starting to compile this. Such a big job may be feasible with Datastage, but should not be the rule. Not on behalf o...

Hi Tobbi, a Job remaining in the Status running happens from time to time and the subject is discussed already several times here, so by doing a search you could have got already an answer. If you have set on "Job administration in Director" you can cleanup ressources or clear status file....

Hi woosy,

Problem 1: You need to find the source of this problem for to stop it. Perhaps you should shut down DS Server once a week.
Problem 2: This is a timeout problem when server hung. This item is already often discussed in this forum. Use the search function of the forum.

Wolfgang

Hi Praj, devide the string into an datepart and an timepart with stringoperations. For example: datepart=MyString[1,9] timepart=MyString[8] in the next round you use an iconv to convert it into the internal datastage date and time format dateintern=iconv(datepart,"D-DMY[2,A3,2]") the timep...

Hi Bapu,

rules cannot be given. Even with 4 Mio. records there are scenarios to prefer OCI over Hash and vice versa. Only rules of thumb can be given.

Besides that you can icrease performance of Hash-Files by choosing an more optimal Hash-File-Type.

Wolfgang

All Windows operators I know shut down and reboot their Windows Clients and Windows Servers at least once a week. In their oppinion it is the best way of keep them running.

Wolfgang

First use the the num-Function to check if the value is realy a Number and the isNull-Function to check if a value is coming. Thereafter you can take the string as number, without an conversion. Sometimes you have 0000-strings before the number therefore we add 0. IF num(FIELD)=1 THEN IF IsNull(FIEL...

Contact your next local Ascential Office. A list you get on:
www.ascentialsoftware.com

Wolfgang