DSXchange

Thanks DSguru2B for your help ! :P But, if the line is NULL (The 2nd row is null : no value, no separator) : ============= ;3247970;1;1;415;0;1;2;1;1901,55;0;26,74;0;0;0,88;30;56,74 ;3248651;1;1;415;0;1;2;1;6533,54;0;116,86;175,62;0,65;4,22;30;323,13 TOTAL CEPME ;;;;;;;;;21441638,65;116531,57;139762...

The file has 17 columns. In the bottom, there is a copy/paste of 5 rows ============= ;3247970;1;1;415;0;1;2;1;1901,55;0;26,74;0;0;0,88;30;56,74 ;3248231;1;1;415;0;1;2;1;1866,72;0;33,39;52,4;0,19;1,24;30;115,98 ;3248651;1;1;415;0;1;2;1;6533,54;0;116,86;175,62;0,65;4,22;30;323,13 TOTAL CEPME ;;;;;;;;...

I understand your reaction and reply. When I wrote "I can't ask", I meaned I don't have permission to explain how to do ?.. :cry: I don't understand that too !.. :cry: Let's return to the technical problem. No manual intervention allowed, only automatical job in Datastage to correct to file.

DSguru2B,
nothing to do in the CSV generating ... Only in Datastage.

Hi DSGuru2B, Yes nothing, just the system character next line. Often, this file CSV is generated from .XLS in which there is some empty rows. Sometimes times, there's only separators : Field1 ; Field2 ; Field3 ;;;; ;; Field1 ; Field2 ; Field3 But, I can't ask the person generating this file to corre...

OK, thanks for this precision.
I didn't know

Thanks kumar_s and ray.wurlod but the DS Server is on Windows Server. So, no sed nor awk...

Hi, I've a problem. Our client has sometimes somes lines with nothing a in his file. For example : Field1 ; Field2 ; Field3 Field1 ; Field2 ; Field3 (nothing) Field1 ; Field2 ; Field3 And the output must be : Field1 ; Field2 ; Field3 Field1 ; Field2 ; Field3 Field1 ; Field2 ; Field3 I dont't know if...

OK, the problem is resolved.
The DS manager missed to implement the routines in my project !

DSguru2B, I have nothing before the warning, only 4 messages. :cry: the routine doesn't run. message = <ERROR> the 4 message of the batch log were : OK Starting Job Batch::... OK Environment variable settings KO Attempting to Cleanup after ABORT raised in stage Batch::JobControl OK Job Batch::EXPOEV...

My problem is due to a call of a function. In the header, I put deffun FunctionXXX(arg1, Arg2) calling "DSU.FWKCommunXXX" it's OK But, the problem appears when I call the function XXX=FunctionXXX(arg1, Arg2) No pb when checking Arg1 and Arg2 separately. How, could I know if DSU.FWKCommunXX...

Breadcrumbs in the children tale Hansel and Gretel ??...
Yes, I have heard this tale !!...


Now, I put some DSLOGINFO in the code and try to find the error.

Do you if there is a batch debugger in the version 7.5 & 8 ?

Thanks chulett.
Could you give me more informations because I don't know "breadcrumbs"
I'am searching in the on-line documentation

:cry: the routine doesn't run. message = <ERROR> the 4 message of the batch log were : OK Starting Job Batch::... OK Environment variable settings KO Attempting to Cleanup after ABORT raised in stage Batch::JobControl OK Job Batch::EXPOEVO aborted. I don't have any information else in Director Shoul...

thanks kumar_s.
Yes, put "INCLUDE DSINCLUDE JOBCONTROL.H" on the top of the code top to test it.

Now, no error in compilation.

Do you know another way to test a batch ?