DSXchange

ray.wurlod wrote:Was the second post a "jitter on your Windows box"?

Yes, in fact it was!

Getting jitter free microsecond resolution from Wintel platform will be difficult. There are hardware plugs-ins that can easily resolve to that granularity, but associating the timestamp to the event still requires the CPU and OS, which are too often busy doing other things. Here's a link to folks f...

Getting jitter free microsecond resolution from Wintel platform will be difficult. There are hardware plugs-ins that can easily resolve to that granularity, but associating the timestamp to the event still requires the CPU and OS, which are too often busy doing other things. Here's a link to folks f...

Is your DS server running on UNIX or Wintel? On UNIX I typed 'sqlplus -help', which gives you info for running from command line, such as this example: sqlplus -S <userid>/<passwd>@<connect_identifier> @<scriptname> The named script contains your multiple sql statements. Don't forget about handling ...

I noticed that you compiled with gcc, what UNIX platform are you on? ISTR that they tightened up on supported compilers, if you read the release notes there is more info. I was able to create a PX routine, just followed the instructions in the documentation. Can't remember if it was *.o or *.so thou...

Maybe others have had better experience with the Merge stage than I. I implemented a full outer join with Merge (uggh, what a PITA for lots of columns). It worked perfectly, but was slow, and metadata changes were awful. I then used the two Xfm stage method, and got, roghly 5x better performance, an...

I have seen instances where the generated and custom SQL statements used different job parameters, and when running the job, you still had to supply values for both.

A minor annoyance.

Carter Shore

I agree that you should push back.
But if you do have to create COMP-3, it's not really that bad (I've done it).

Let us know.

Carter

Are these Call Detail Records? Depending on the record format, there is often feature encoding at the bit level, as well as BCD encoding of digits. Not convinced that DataStage is the right tool for this job, but if you insist, then you wil probably have to disassemble each record piece by piece, ie...

True for the buildop, but don't Custom Functions become available to choose via the expression editor menus in Parallel Transformer?
ISTR adding one (it's been a year or so back).

Carter

Since it's EE, why not a function or buildop based on C regcmp and regex?
Build it generically enough for re-use, and voila, you have a new arrow in your quiver.

Carter

Tough to do in plain Sql without some kind of calendar table, but assuming you DO have column 'date' in 'dateTable', this will count the weekdays in a specified year and month: select count(*) from dateTable where to_char(date,'YYYYMM') = '200608' -- specify the year and month and to_char(date,'D') ...

Yikes,
Been a while since I set mine up, and have not touched it since.
ISTR that you install/modify the Message Switch using the Install CD.

Is it hosted on a Windows or UNIX box?

I can find the Docs somewhere if that helps any.

Carter

Or,
try nawk:

nawk -F'@@#' '{print NF}' yourFile.xml

The -F specifies a Regular Expression for field seperator, the NF is the number of fields.

I don't think '@' or '#' are ERE metacharacters, but if so, just backslash escape them.

Carter

Append a comma to each field except the last.
Redefine the width of each column by one.
Write them as fixed width.

Carter