UNLOAD files problem

[sroz]

hello,

i have a problem with unloading tables to files : i get empty lines in the result file. when i want to load it, i get an error.
does somebody know where it can come from ?

 

[PHV]

Can you please post the code used to unload the tables ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sroz]

UNLOAD TO 'tempLog.txt' DELIMITER '|'
SELECT * FROM tempLog WHERE severite <> -1;

 

[PHV]

Are the empty lines at front, at end or at random location in the file ?
Can you post a (short) example of result lines exhibiting this behaviour ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sroz]

empty lines are at random location. i think it doesn't depend of values of lines, i have many lines like this "2655|-1|-1|0|0|0| | |Noeud inconnu|1|" with no error.


2654|0|1119|4|1119|||||1|
2655|-1|-1|0|0|0| | |Noeud inconnu|1|
2656|-1|-1|0|0|0| | |Noeud inconnu|1|

2657|0|1120|4|1120|||||1|
2658|-1|-1|0|0|0| | |Noeud inconnu|1|
2659|-1|-1|0|0|0| | |Noeud inconnu|1|
2660|0|1121|4|1121|||||1|
3131|-1|-1|0|0|0| | |Noeud inconnu|1|
3132|-1|-1|0|0|0| | |Noeud inconnu|1|

3133|-1|-1|0|0|0| | |Noeud inconnu|1|
3134|-1|-1|0|0|0| | |Noeud inconnu|1|
3135|-1|-1|0|0|0| | |Noeud inconnu|1|
3136|0|1331|4|1331|||||1|
3137|-1|-1|0|0|0| | |Noeud inconnu|1|

 

[PHV]

No other process dealing with tempLog.txt during the unload ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sroz]

there is only unlaod to templog.txt which is runnig