DSXchange

We use message queues so luckily I could write the information into a message queue and read from there for my error reporting module. This is much more elegant than writing to files and dealing with their management. Also, the corporate wants messaging to be used extensively...

Thanks for all the valuable inputs. I really appreciate it. I think I will try to use the named pipe approach and also would like to try the column merge thing to see if its going to do me any good. The problem with column merging is that I have to do a seperate merging for every job. If I am prepar...

I actually have to write the row and other information to an MQ message, so that the error reporting job will pick the message up and email it to a destination email address. Writing to a file will impose file structure maintenance challenges (we have a lot of these jobs running and all of them need...

I am trying to construct a long delimited string which is basically a consolidation of all the fields in 1 row of a stage at a time. I know that I could do something like: InputLink.Field1 : '_' : InputLink.Field2 : '_' : ... InputLink.Fieldn in the transformer, but I need a re-usable object here to...

Appreciate the responses. Somehow I could not find the topic "command line interface" earlier, now I can!

Thanks.

Can anyone tell me how to run a server job from the command line on a unix box. I could not find it in the help or anywhere else!

I could find how to compile and generate report from command line, but not how to run it without using director.

Thanks.

Thanks for the quick primer. I get it now, I got carried away with that lookup stage from the parallel job documentation earlier.

It may be that I don;t have an enterprise edition - that's why I cannot see the database lookup stage... but anyway, this solves the problem for now.

I cannot find the lookup stage in my pallette. This stage is mentioned in the parallel jobs documentation, and now I cannot find a parellel job option in my datastage client. What's going on here.. is it like the edition I have is not the enterprise edition? or is there something like a menu option ...

It's a great response guys! I haven't tried the solution yet because of some other hold up, but I am sure it will work. Although, I was just wondering, what was the source for this type of information when you encountered this problem the first time. The help is not all that helpful often times! Wha...

I was wondering how could we skip a pre-determined number of lines in a sequential file? We have integrity checks such as no. of rows of data and\or checksum of the file, marked up at the very end (or sometimes even in the beginning) of the file. How can we make the sequential file stage to skip a f...

I don't know the answer to ur Qn - but then again, to attack even the basic problem - how do we skip rows that are not data. For example, one of the files I have to deal with has some human readable header content like, for example, no. of transactions in the file or something like that. Now, I know...