DSXchange

I used the macro (predefined job parameters) #DSJobWaveNo# (increments per-job-run, resets on recompile). in both filename and transformer.

It worked perfectly!

Hello, I need to get a parameter with a timestamp to be used within the job and to create the file name of a sequential file. The timestamp can be the time the job started for example and then put into a parameter. I cant use sequencers, the job is started from SAP-listener. I can use environmental ...

I think I have the same problem. I'm doing a lookup on a table in a DB2 database. The field that I'm trying to do the lookup with is a varchar(16) and the data is '111222333'(9 characters). It fails. If I hardcode the data in the previous transformer it works. (Not using the DSLink.xxxxx input.) If ...

Thanks for your answer. It doesnt seem to work, I'm supposed to do this inside the MQConnectorPX stage, right? Using a parameter? Unfortunately I can not put any more time in to this, my boss says no, he has some kind of work around, in the MQ-server side, I think they made two diffrent queue's in t...

Hi, thanks

I'm not able to install any other applications, because of the client. I'm not able to connect to the MQ, but I'm probably not doing it right.

But what about the port on the MQ-server beeing changed, from 1414 to 1421, dont I have to specify that somewhere in DS?

/M

I dont know how to do that, if you have time to guide me I will be grateful.

thanks,
Mattias

Hello, I can not connect to the queue manager and get error 2059. I'm using the Client mode. I have checked that all parameters are correct. I hardcoded them. It worked perfect before the port was changed on the MQ-server. Am I supposed to change this somewhere? I cannot find that configuration. Tha...

How did it go? (I realize that you might not see this ;-) I hope it's ok that I hi jack this thread. I have a similar problem. i tried putting all my fields to unicode and not unicode. I extract my data from an IDOC in UTF-8 and insert it to a seq. file with ISO-88859-1. main_program: Invalid charac...

Hi, Trying to generate a default value from a Column Export stage in my parallell jobb. I have one column coming in and I need two going out, one with a default value,"DS rocks" for example. In the Edit Meta Data page for the new specified column I have the Field level: option "Genera...

Sorry to hijack your thread but I have exactly the same problem, did you ever stumble over a soloution. I cant delete the projekt so I have my ROOT job laying there bothering me.

Thanks,
Mattias

Works perfect, thank you very much. THX!

Now I will hit the aggregator...

I tried your first suggestion and it gives me a sequence of numbers, 1 to 6.I would like to get the first 6 rows to be one group, and the following 6 to be another group. This way I will be able to aggregate my rows that look like this with the desired group column included: "1","Grou...

Creating a grouping column would be perfect, just the way you describe. You also point out that it's easy with stage variables. Sorry but it doesnt seem to be easy for me. Can you please give me a s short description. It would be very helpful.

Thx,
Mattias

Thanks! Is it possible to do it without one stage variable for each column? I might need more columns in the future. It's always good to be prepared :-) If you have the time make the description a little more detailed I would be very greatful.. It's been some time since I developed in DS. Please. Th...

Hello! Here is my problem. Only one column. Only one record on each row. Heading A B C 1 2 3 Z X Y 4 5 6 I need to get this into rows: A B C 1 2 3 Z X Y 4 5 6 My example data is very accurate. This is the exact way my data is structured. There are many solutions to this but they all have a key colum...