DSXchange

Chris, do you have any idea how difficult it would be to teach you how to do UNIX shell scripting here, one post at a time? I'd made a suggestion somewhere in one of these posts to talk to your SAs and I'll make it again. If not an SA, there must be some kind of scripting guru wherever you are worki...

Clear as mud. How does one 'generate an xml file by combining DAT files'?

Perhaps it would help if you posted examples of these oddly delimited records.

You need to take what Ken gave you and understand what it does. Cut can work much like the DataStage Field function or substring depending on the options used. His specific example says that the fields are space delimited and he wants the third field. No sizes involved. Read the man pages. Get yours...

I don't think I've ever seen XML with delimiters like that, but regardless... Clarify exactly what you've got. Is it one long 'record' that you need to break apart around this three-character delimiter or something else? If you do a 'wc -l' on the file, does it return a 1? I don't recall any built i...

All of these 'in UNIX' questions, you mean in a script like a korn shell script?

For the '/' question, you can look into the 'cut' function or perhaps even 'basename' and 'dirname'. Check the man pages for each.

Also, your SAs are typically good scripting resources - talk to them.

Ok, point conceeded - if transcribed in a highly inaccurate manner. Here are some Server SDK samples: DateGenericToTimeStamp DateTimeStampToOraOCI DateTimeStampToOraOCIWithTime They all take an "SDK timestamp" which is "YYYYMMDD HH:MI:SS.TTT" format and something I never use. And I'm obviously misre...

Peripatetic.

This is not possible with the current engine (which can only partition on key values, and the log table has a sequential integer key) but might be possible in Hawk. Not sure what you mean here, Ray. As noted earlier, it is perfectly feasible to get log entries for individual invocation ids using th...

The same i have tested using a dynamic RDBMS it data is read if i use a to_char(field) in my query. You're saying that it works using an RDBMS stage but doesn't using some other unnamed stage. To be complete, rather than have people assume they know what the other stage is, how about you give some ...

What debate, Ken? It says it handles both in the manual, so that must be how it works... right?

The datatype is Varchar.so its not CHAR either. Ok, being picky here but datatype in DataStage does not guarantee the type in the database. You can't make an assumption based on the job that it must be a VARCHAR2 field in Oracle just because the job uses a Varchar. Check the actual Oracle field. Ob...

TRIM(link.column) takes care of trailing and leading and repeating spaces if you want a simpler way. Actually, TRIM without the character specifier trims (per the manual) "spaces and tabs". Once you start using TRIMF and TRIMB, you cannot specify what to trim, so it does spaces and tabs. These two ...

No, they're not. There are no Server SDK routines or Transforms with dots in their names. This is more like the typical PX function naming style, from what little I've seen, hence the question. If it's truly a Server job then it's a home grown routine. In any case, check the code and the internal do...

No, that should cover it. Only one minor correction, not sure if it's critical or not but SYBASE_OCS should just be the version, AFAIK: SYBASE_OCS=OCS-12_5; export SYBASE_OCS And just for completeness, if you are on a mixed mode server, i.e. - one that can run 64bit or 32bit code - make sure you spe...

Ok... now that I can buy.

Still gonna add it to the old bag o' tricks.