Est ce qu'un tDBinput peut contenir plusieurs requetes

[sinoun]

Bonjour à tous, j'essaye d'executer un sql dans un tAS400input, les requetes sont bien exécutées dans la partie gauche (connexion) requetes metadonnées mais dans lorsque j'execute le job avec un tas400 qui contient ces requetes il m'affiche le code erreur suivant:

Exception in component tAS400Input_6
java.sql.SQLException: [SQL0104] Elément syntaxique ; n'est pas correct. Eléments possibles : <FIN-INSTRUCTION>.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1342)
at com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:1949)
at premier_job.autre_job_0_1.autre_job.tAS400Input_6Process(autre_job.java:2560)
at premier_job.autre_job_0_1.autre_job.runJobInTOS(autre_job.java:3108)
at premier_job.autre_job_0_1.autre_job.main(autre_job.java:2968)

Merci pour vos réponses

[haskouse]

Salut,

Peux tu passer la requête SQL pour voir ?

[sinoun]

Salut,
voici la requete
update simco.bx_FGironDatArr set

DebutPeriode =
year ( current date - 1 day ) * 10000 + month ( current date - 1 day ) * 100 + 01,

FinPeriode =
year ( current date - 1 day ) * 10000 + month ( current date - 1 day ) * 100 + day ( current date - 1 day ),

DateArrete =
year ( current date - 1 day ) * 10000 + month ( current date - 1 day ) * 100 + day ( current date - 1 day )
;


-- for?age ?ventuel des dates
-- update simco.bx_FGironDatArr set DebutPeriode = 20110101, FinPeriode = 20110331, DateArrete = 20110131 ;


-- calcul
update simco.bx_FGironDatArr set

DateArreteMoins1Mois =
year ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 1 month - 1 day ) * 10000
+ month ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 1 month - 1 day ) * 100
+ day ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 1 month - 1 day ),

DateArreteMoins3Mois =
year ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 3 months - 1 day ) * 10000
+ month ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 3 months - 1 day ) * 100
+ day ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 3 months - 1 day ),

DateArreteMoins6Mois =
year ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 6 months - 1 day ) * 10000
+ month ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 6 months - 1 day ) * 100
+ day ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 6 months - 1 day ),

DateArreteMoins12Mois =
year ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 12 months - 1 day ) * 10000
+ month ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 12 months - 1 day ) * 100
+ day ( cast ( substring ( cast ( DateArrete as char ( 8 ) ) , 1 , 4 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 5 , 2 ) || '-' || substring ( cast ( DateArrete as char ( 8 ) ) , 7 , 2 ) as date ) + 1 day - 12 months -1 day )
;

select * from simco.bx_FGironDatArr
Merci pour t'as réponse

[Benoit_Durand]

Déjà il faut virer tous les commentaires en -- ou les remplacer par des /* */ car dans le code généré ça peut faire n'importe quoi.

Ensuite je sais que certains composants comme le tMSSQLInput peuvent lancer plusieurs requêtes alors que d'autres comme le toracleInput ne peuvent pas. Pour le tAS400Input je ne sais pas désolé.