DSXchange

ray.wurlod

You've missed the "%" signs on the date format descriptors. Try

DateToString(StringToDate(Trim(myDate), "%dd/%mm/%yyyy"), "%mm/%dd/%yyyy")

And, of course, for this to work your input column (myDate) must be a string.

ray.wurlod

Begin by importing the Sequential File table definition. This will automatically be translated into a schema definition for you.

ray.wurlod

Congratulations of the success of your research! :D

ray.wurlod

Welcome aboard! :D

Are you running on Windows XP with service pack 2? There are known issues with SP2.

ray.wurlod

File too large usually means that the file has reached the maximum size permitted by one of your ulimit setting or by the operating system. For example, if the O/S limit is 4GB and the file is already 4GB, this error will occur for any attempt to append to the file.

ray.wurlod

The word "nullable" would be a good start.

Code: Select all

record
(
  lastname: string[max=16];
  middlename: nullable string[max=16];
  firstname: string[max=16];
)

ray.wurlod

What is the unit of measurement of duration? Seconds? Days? You need to know this before you can perform arithmetic with dates. Search the forum (or the Orchestrate manuals) for the APT_Date class and the various constructors available with it.

ray.wurlod

What is the unit of measurement of duration? Seconds? Days? You need to know this before you can perform arithmetic with dates.

ray.wurlod

Agreed. Unfortunately not everyone uses an electronic modelling tool. Some design on paper.

ray.wurlod

I was asleep at the time, so refuse any blame. (I was going to quote Bartholomew J Simpson there, but thought better of it.)

ray.wurlod

Does the invoked routine execute either an ABORT statement or the DSLogFatal() routine? Does the job control routine execute either of these? If so, start looking there.

ray.wurlod

What Craig said is 100% accurate and what my earlier post intended to convey.
Array size is only about how many rows at a time are sent to Oracle; this has nothing at all to do with undo table space.

ray.wurlod

No.

There is no fix to this from DataStage apart from using smaller transactions.

Otherwise you have to negotiate with your DBA for a larger undo tablespace.

ray.wurlod

Welcome aboard! :D Since the problem is in row #1, does the file have column headings but you forgot to check this box in the Sequential File stage Format tab? Otherwise, what is the actual value in the fec_finvig column being sent to the Informix table? You can use the Debugger or stage tracing to ...

ray.wurlod

Not Red Brick. RedBack. Two very different products. RedBack would not be appropriate for the MetaStage directory; it only talks to UniVerse and UniData. The MetaStage directory is (currently) a "database of your choice".

Search found 53125 matches