DSXchange

ray.wurlod

What is the data type of the column you're sorting?

Incidentally, DataStage sort in 8.1.1 and later will always out-perform Unix sort. The option has really only been left in the stage for backwards compatibility.

ray.wurlod

Use whatever you get when importing the table definition using the Connector Access Wizard.

ray.wurlod

Ur was a city in ancient Babylonia. The second person personal pronoun in English is spelled "your". Plz may be a town in eastern Europe. The word you needed is spelled "Please". We strive for a professional standard of written English here at DSXchange, not least to assist those...

ray.wurlod

Always start with the first error - "unique constraint (SCOTT.SYS_C005447) violated". There's nothing wrong with the DataStage job design. You're trying to insert a record that violates the indicated UNIQUE constraint. Answer: don't. Perhaps add some checking to your job.

ray.wurlod

Client connects via the DataStage RPC mechanism and, in so doing, inherits the environment of dsrpcd. Perhaps that environment includes REMOTE_DB_INSTALL_LOC ?

ray.wurlod

I can't recall whether you can use IN, but you can certainly use OR to construct complex survive rules.

ray.wurlod

Data type Date is stored in a four-byte binary format.

ray.wurlod

There is no such thing as a sample record from RT_STATUSnnn - records for different object types have different structures. Enjoy.

You haven't actually shown the key values. Try this query.

Code: Select all

SELECT @ID FMT '50L', F1 AS OBJECTTYPE FROM RT_STATUS97 USING DICT VOC ORDER BY 1;

ray.wurlod

GTAR = general technical assistance request; it means contact your official support provider.

ray.wurlod

Show them some of the testimonials.

When you've got 'em by the testimonials, their hearts and minds will follow.

ray.wurlod

CurrentDate() is not a string, so Convert() will not work on it. Leave it out.

Code: Select all

DateToString(CurrentDate(),"%yyyy%mm%dd")

ray.wurlod

Can't TCS afford to cover you? Corporate discounts are available. Details available from link on Home page.

ray.wurlod

Assuming that the data type of Phone is string (of some kind):

Code: Select all

If (Len(InLink.Phone) = 11) Then InLink.Phone Else "0" : Right(InLink.Phone,10)

ray.wurlod

What are the data types for this column on input and output links?

Perhaps the difficuly is in an implicit conversion, and data that cannot be successfully converted given your default timestamp format setting.

ray.wurlod

You can switch case sensitivity on for LDAP in the Advanced page of Global Security in the WAS integrated console. If you really want to.

Search found 53125 matches