DSXchange

ray.wurlod

This is why it's so important to post the exact error/warning message, rather than "something like". Without the exact error message we're only guessing at best.

ray.wurlod

Kernel settings on AIX are different from those on Solaris. Check the installation manual for details.

ray.wurlod

kstechno wrote:And I m not premium member of this website. So that I cant read your message reply.

This link might help.

ray.wurlod

srinivas.g wrote:upcase(columname[1,1]):column[2,length(columnname)]

... yields "Sam smith-jones"

NOT what is required.

ray.wurlod

Code: Select all

UnxCmd="opt/BIM/SCRIPT/TUS_count.sh /opt/BI"

ray.wurlod

Vertical pivot. Search DSXchange for examples.

ray.wurlod

It's clever enough for that and O'Brien as well.

ray.wurlod

Yes, the Index() function.

Code: Select all

Counter = 0
Value = DSGetParamInfo(hJob, "jpSearchString", DSJ.PARAMVALUE)
Loop
While ReadSeq Record From fOpened
   Counter += (Index(Record, Value, 1) > 0)
Repeat
Ans = Counter

ray.wurlod

Try Compare or Difference stage type.

ray.wurlod

Not without using a different stage type.

ray.wurlod

You'd have to write your own function, or use the "MCT" conversion in a BASIC Transformer stage. There's nothing out of the box.

ray.wurlod

Shouldn't think so. Are you using ODBC or the SQL Server Enterprise stage?

ray.wurlod

There is no year number 0. Would you care to re-state the definition of Julian date?

Mod() and Pwr() are available. What do Record() and Over() do? Did you mean to nest these two?

ray.wurlod

"The correct one" is the one to choose. Your poll is meaningless. It's not about stage type, it's about data type of the key for which adjacency needs to be established (Modulus is only for use when the key is an integer of some kind, Hash is the other key-based algorithm to be used for al...

ray.wurlod

If you read my whole message you will find that I do know.

Search found 53125 matches