SQL+ Question

[Sofiane]

Hello,

I created a script to generate a second script. When I direct the resultat of the first script to a file (using SPOOL command), I have the following text in the first and last line :

Input truncated to 1 characters

Input truncated to 11 characters

I didn't find how to eliminate these in the generated file
( feedback and echo are set to off).

Could you tell the signification of these lines.

Thanks a lot for the help.

Sofiane

[Chris]

Hi,

I think this is caused by carriage returns in your script.
I can't remember whether you should remove the carriage returns or add them, but it's one of the two.

hope this helps

chris.

[Slaine]

Sofiane

You do not need to worry about this message
In order to get rid of it ensure you have a new line character at the end of your script.
If your script ends with a ; or a \ then just put in a new line character to eliminate the message

Cheers

[Sofiane]

Hello,

Thanks a lot for the reply. It's OK for the solution.

Another question :
I would like to avoid to 'hard code' with the Spool command the file path. Is it possible to generate the file in the directory of the first script. In other word :

Suppose that my first script (script_0.sql) is the following :

Set linesize 120
...
...
Spool CURRENT_DIRECTORY\Query_result.txt
@CURRENT_DIRECTORY\script_1.sql
Spool off

I would like to replace what I called CURRENT_DIRECTORY by something in order have script_1 and result in directory in which script_0 was stored (Machine independant).

Thanks