DSXchange

Yes, you can run multiple instances of the engine. The keyword to look for is "itag" or "instance tag". You will only be able to run one instance of a 5.x engine on a given server as the multiple engine capability was not present at version 5.

The answer is to lie to DataStage. Specify a length of 2Gb for the field.

RakshaPai wrote:...i changed the datatype of cprsrc_end_dt to varchar(23), i am geting no error but then there is no data in the file.....

Use an editor to look at columns 1 - 23 of your source file. What does it look like (i.e. post it here if the solution isn't apparent)

Did you code the sub loop logic in C++? Since you posted in the PX forum that would be my assumption so your other logic would have to be written in C, and there are other forums that can help you with that code. Or are you using a mix of DataStage Sequence job / Shell script / DataStage BASIC code?

The code is not present, i.e. the routine was imported into the project with only the object code.

Ray -

news78 wrote:We get a data flat file which has just one line...

For some reason the routine is trying to create a file that is already in the VOC. I can't check the code (but you can) to see if this might be because an attempt to open the file failed. If you can enter the UV shell or use the command line in the administrator, try executing "COUNT SDKSequences" a...

In which stage is this error occurring?

Brad - you have hit upon the solution that I was thinking about as well. Just declare the original with one column of fixed width and no line terminators, then read it in.

Abhilasha - have you identified your bottleneck? Is it CPU, I/O, Memory? Have you tested with different number of nodes in your configuration file to get the optimum for that job? Are DS and Informix on different machines (if yes, is the network bandwidth sufficient)? These are just the first questi...

As Ray has said, the 2 environment variables need to be set in order to call orchadmin , but it will use the configuration file embedded in the dataset unless you set the command line to use the current config file. That means you can delete a dataset with a different configuration than the currentl...

Can you echo the arguments as well, then manually test the routine to see if the return value is the same? Shouldn't there be more than one output if you call this in a loop? Can you look at your routine and see where the variable "Ans" is assigned?

...If(UpCase(Convert(' ', '',<column_name>))=UpCase(Convert(' ', '',<column_name>)) then 'Y' else 'N' ... Since your code on both sides of the = sign is identical, this will always return 'Y'. I am sure that this isn't what you intended. Did you mean <Column1> and <Column2>?

DataStage jobs have no direct knowledge of the mail application, this is taken care of inside dssendmail.txt in your project directory. If you have a non-standard mail command syntax you can change this file to accomodate this alternate mail program. You do need some mail client software to be insta...

Please try using search before posting a question like this, you will find that it has been asked, and answered, many times in the past. If you create a new sequence and don't have the same problem, then the job design information for that sequence is most likely corrupted and you will have to re-w...