DSXchange

If a DataStage hashed file/table has an index on a column, any SELECTs that use that column as part of the selection criteria will use the index. If the index has somehow become corrupt or invalid, a SELECT on that file will return incorrect rows even though the file itself contains the correct info...

That is very odd behaviour; since the round-robin will distribute the rows one at a time to each successive link. You should be getting 4,4,4 rows going down each path. I've just done a quick test and that is the behaviour I am seeing. Are you 100% certain that you've specified round-robin in your c...

Hello Guysma and welcome to DSXchange. I am sure that come tomorrow you will get some answers from people who've used DS390 recently and who will hopefully be able to assist you. I did want to suggest that you use lowercase to enter your queries, as using all uppercase is considered shouting.

You didn't declare the length correctly, otherwise you wouldn't be getting the error message. The correct length of your file is 144 bytes per row, and you declared only 13 bytes of it. You have other options in the PX sequential file stage to have it ignore incorrect length specifications but I'm n...

naren - if you have a full pathed hashed file you need to use OPENPATH, not OPEN.

Declare the length correctly, add a new dummy column with length 131 that you don't use.

kumar_s wrote:Trim also works for Char...

Kumar, what does TRIM() on a CHAR(10) field containing "hello " return?

Naren, Here is a shell program that is a "hint" - it doesn't use COMMON to skip re-opening the file and only uses a simple key, one column with your 0 or 1 STATUS and one column with the next key. Don't just copy this and run it - there is no error checking or handling and you should go through each...

In a wonderful display of Customer Service effort, I received this response from Pearson VUE: Sir, Unfortunately I have to ask you to contact IBM directly to find out which code they use with us. Without the correct code I'm afraid I can't help. Thank you. Jonathan Addams Pearson VUE after I had pas...

A typical source control system with it's check-in and check-out would only work on .DSX or .XML flat files extracted from or loaded into the projects. I've seen this done but it was quite unwieldy and, IMHO, unmanageable for the longer.

What does your user SQL read?

If your data type is VarChar and trim doesn't work then you don't have spaces in your string. But I looked at your code and

StringToDecimal(Trim("FieldName"))

will not work, you need to remove the 2 double-quotes so that the value of the parameter is used, not it's name.

The TRIM will only work on VarChar and not CHAR columns.

Where are your webpages being read from? Normally the pages will contain only HTML text and reference other non-text data. There is a Click Pack to help you work with the log files, but it doesn't help with the actual pages. You can strip out unprintable text (using the ;'MCP' conversion) to clean o...

Use TRIM() to remove the spaces that the StringToDecimal function can't handle.