DSXchange

Guy, You can still interpret these "switches" as if they were unsigned numbers, one character at a time using the SDK routines. I don't have DS running now so I can't do a quick example, but you can interpret this information for yourself. There are various ways to do this. If you were to take SEQ(I...

No Problem, it is not as if a group of dark-suited "license Police" are going to come crashing into your data centre to impound the machine The difficulties are not so simple with CPU-based pricing. The last client I was at was running on IBM hardware and activated SMT (simultaneous multi-threading)...

Hello Guy, as Kumar has pointed out, this is in actuality a packed data type. There are a number of builtin routines in DataStage that can convert to and from these data types. You will need to find out if the datatype is signed or not, as this affects how to unpack the data. Once you know your data...

I have been doing some testing on relative performance of hashed files at my current site, but believe this applies to many different sites and wanted to open a discussion on the subject of Dynamic Vs. Static hashed files. In the configuration here (multi-CPU AIX, 1000+ daily jobs) there are many ha...

Kumar, even though it doesn't seem right, Las Vegas is really a central place to hold a conference. The cost of flights there is inexpensive, cost of staying there is much cheaper than most places, the conference facilities are great and most people want to visit there. Holding a similar conference ...

sudheer,

by media Stephen was referring to the install CDs.

alraaayeq, this is something you need to clear up with your DataStage sales representative. DataStage licensing is based upon the number of processors, you purchased a license that lets you run DataStage on this system with 8 cpus, but you have put in more and that is a violation of your contract wi...

Create a stage variable called FoundRow, use the derivation



Then make a constraint stating

FoundRow = 1

and Bob's Your Uncle {sorry, I'm in the UK right now and I've been yearning to use that colloquialism}

You not are going to get a lot of answers to this one.

Please provide enough information to assist in localizing the issue. So far we know the DataStage job is aborting. That's about it.

RayNother, I don't have the source to see what the routine DateTimeStampToInternal is doing, but if your incoming data is in the form "YYYY-MM-DD HH:NN:SS.mmmm" (or shorter), then: Oconv(Iconv(DSLink7.Date)[1,10],"D-YMD") + 1,"D/YMD[4,2,2]" ) will do the trick.

If you look at your successful run in the director I am 100% certain that it will say "1 row processed", and not the 30 you expect. Most likely you have not declared the sequential file attributes correctly for the file you are reading. PX is quite finicky about this - Fixed Length? - Quote characte...

Kumar,

you can have the sequential file stage ignore a missing final delimiter. One job has it set and the other does not.

Ray,

I didn't know that - I am assuming that you mean the Windows AT command running from the client's system? That would also explain the different behaviour in this case.

I've been resisting the beck and call of writing c++ externals for PX for so long, but this routine is so simple that even I should be able to bind it in within a week's worth of work. So even if I get a solution from Ascential I'll still use Carter's code for my first attempt at this esoteric art I...

clshore, to add to your computations, the CRC32() algorithm is designed to ensure that sequences that are quite similar will produce very dissimilar results, so that in this example the odds are further reduced by the data being constrained to mainly +-60 characters and maximum length of 200. The li...