DSXchange

Keerthi,

If I understand your question correctly, which I doubt, you have written a sequence that should loop infinitely, but it doesn't. Just as Sainath posted, you will need to supply us with more information and messages before any meaningful analysis can be made.

This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result.

Hello Mandyli, I think every one of us has encountered some form of this warning message when using a Px Aggregator for the first time. Fortunately detailed explanations have been covered numerous times in this forum. I did a quickie search for "When binding output interface field " and got lots of ...

I would like to see a built-in switch, either at a stage level or even at a column level, that would perform a TRIM() of all leading and trailing spaces plus 0x000 characters for VarChar columns in both Server and Px plus the same for CHAR columns in Server. I invariably end up doing this when my da...

Most likely at some point in time the column with the trailing 0x000 data was defined as a CHAR or a PIC X type field and it was padded automatically with the low-value or null (empty) value. You can do a TRIM(CONVERT(CHAR(000),CHAR(032),YourColumn)) to remove these extraneous values. Addendum Oops,...

Tracy, can you go into a UniVerse session and do a "PORT.STATUS". Can you identify the hung process from the PORT.STATUS output, if so, then the last command executed and the number in square brackets will tell you in which program at which line the process might be stuck. In some cases the LIST.REA...

If idea of the Ascential benchmark center survived the IBM takeover then they would certainly be more than a bit interested in this type of information (particularly when DSXchange results differ from published numbers) Nonetheless I would consider this type of data to be very valuable to those of u...

dhiraj, you will need to create a VOC entry to this file and enter information in the DICT portion - once that is done you can use CREATE.INDEX and BUILD.INDEX to put your secondary lookup key on your columns C and D. If speed is very important then it would be advisable to create another hash file ...

vigneshra, when you compile and catalogue an after-job subroutine a single copy of the code is placed in the catalog space; any job that uses a subroutine with the same name will get the current copy. If you change & recompile this routine all jobs, except those that are currently running, will ...

ogmios, I don't know which tables were referred to specifically, but the method is to explicitly disable use of the alternate keys (indices) on one query while allowing it in the other. The main table to compare would be, in my opinion, DS_JOBS ; so you could do a "LIST DS_JOBS WITH JOBTYPE NE 0 BY ...

I would avoid trying anything tricky using the DataStage internal tables and structures. The easiest method would be to do an export of all your jobs into a .dsx file. Within the .dsx file you will have a repeating construct along the lines of: BEGIN DSSUBRECORD Name "MyParameter" Prompt "Prompt..."...

Bharathi, the keyword you would use to search the forum is "checkpoint" and you will find numerous threads on different ways of doing this. As you have DS 6.x there are some new functionalities that are not available to you, but you still have a number of options. If your input is always going to be...

User functions & jobs will get catalogued with a DSU.<name> format; other prefixes or formats are used within the product itself and are not encountered in normal DS use.

Kim, I think that it would be great to get a wide list of performance numbers for a baseline of common type of jobs. Jobs along the general line of: 1. Read sequential -> Write Sequential 2. Read Sequential -> CPU transforms -> Write Sequential 3. Read Db -> Write Sequential 4. Read Sequential -> Wr...

Good morning Ravi, the job of estimating project complexity and duration is more of an art than a skill and there is little in the way of supporting documents or even procedures that can replace experience. Since DataStage and similar tools are meant to replace hand-coding a solution in a programmin...