DSXchange

Are you not able to open the job as well or just only the at the time of export? If you can open the job, try compiling the job or a force compile. To the best knowledge I have, cleanup resources is the only way to find the PID for a job. And all you need to do, is the export for now, you can try to...

I dont think you need admin right for this. Double check your process ID.

Alternatively you can login to your Admin client (As a developer), and try to kill it from there, with job name I guess.

Thanks Ray. I did develop the job, and it was working good. But had to do a lot of setup for passing values to those parameters.

Thanks for the info, Ray & Andy!

If your XMLs will differ only with the number of columns, I believe you dont have to worry about it. You can code your job with the maximum available columns and select "replace empty with NULL", you should be good to go. If you have different XML structures, where your X-Path will differ ...

ray.wurlod wrote:They are simply not available in the parallel Transformer stage, and never will be. ...

Hi Ray, I was hoping to see these functions in parallel transformer one day, just like ereplace made it in 9.1

Is there any particular reason why you mentioned that they will never be available?

Did you check the server load in your production environment? Are there other jobs running at the same time, using more memory which might be affecting this job's performance?

Just out of curiosity. All the EBCDIC files are fixed width, isnt it? Where do you actually get this padchar issue?

And also, did you try giving the value for "APT_STRING_PADCHAR" as ' ' ?

I guess his output to be a typo, as he even missed '7'. If my guess is right, you can have your stage variable as below: StagVar1: StagVar1 : ';' : ColumnA : ';' : ColumnB : ';' : ColumnC StagVar2: Trim(StagVar1,';',"L") set you stage variable's initial value as Empty ( '' ) Assuming that ...

If it is the same table you are using and just the different columns depending on the 'date' parameter, why dont you just pass this date to the job and use it in your source query? Why do you need two jobs?

kirankumarreddydesireddy wrote:If I enable the "Contains Terminators" to yes,I am able to read the value of this field as "hi this",the remaining text "is rakesh" is ignored.

I believe that might be the problem with your viewer. Try double clicking the column value and check if you see more values.

Try the below in your output column derivation. The value '10000000000' in the derivation depends on the maximum digits you get after the decimal point.

Column * (10000000000[1,(Len(Field(Column,'.',2))-1)]

Does that really depends on the domin you work on?

I'm not sure if there's a function in parallel but if you can use a BASIC_Transformer, you can use Oconv('String',"MCN") to just get the numbers alone from your string.

For your 2nd question, you can create a job, which overwrites the output file from a null file and call it in the job sequence only when it is your first instance and by-pass it for the other two. And in the core job you can always use 'Append'