Bonjour,
Comment utiliser ce type de requêtes avec options dans Perl?, exemples:
* db2 set current sqlid="un_login"
* db2 -c ...
* db2 -f "fichier.txt"
* db2 -s "requete"
* db2 -tf ...
* db2 -stf ...
Le simple lancement avec DBI je le connais mais je veux respecter les options.
Merci d'avance.

# RAPPEL DES OPTIONS DB2
======================
> db2 ? options
db2 [option ...] [db2-command | sql-statement |
[? [phrase | message | sqlstate | class-code]]]
option: -a, -c, -d, -e{c|s}, -finfile, -i, -lhistfile, -m, -n, -o,
-p, -q, -rreport, -s, -t, -td;, -v, -w, -x, -zoutputfile.

Option Description Default Setting
------ ---------------------------------------- ---------------
...-a.....Display.SQLCA.......................................ON
...-c.....Auto-commit.........................................ON
...-d.....Retrieve.and.display.XML.declarations........ON
...-e.....Display.SQLCODE/SQLSTATE....................ON
...-f.....Read.from.input.file.................................ON
...-i.....Display.XML.data.with.indentation..............ON
...-l.....Log.commands.in.history.file.....................ON
...-m....Display.the.number.of.rows.affected..........ON
...-n....Remove.new.line.character.......................ON
...-o....Display.output........................................ON
...-p....Display.db2.interactive.prompt..................ON
...-q....Preserve.whitespaces.and.linefeeds...........ON
...-r....Save.output.report.to.file.........................ON
...-s....Stop.execution.on.command.error..............ON
...-t....Set.statement.termination.character..........ON
...-v....Echo.current.command............................ON
...-w....Display.FETCH/SELECT.warning.messages...ON
...-x....Suppress.printing.of.column.headings.........ON
...-z....Save.all.output.to.output.file....................ON
Notes:
Use the DB2OPTIONS environment variable to customize option defaults.
An option takes on the opposite value if the minus sign (-) is changed to a
plus (+).
Use UPDATE COMMAND OPTIONS to change option settings in interactive or
file input mode.