As400

Article View: es.comp.lenguajes.java

Article #932

Back to es.comp.lenguajes.java Previous Next

#932

From: Yamilé
Date: Thu, 26 Oct 2006 20:10

24 lines
1838 bytes

Puedo utilizar CallableStatement para hacer un llamado a un programa
del as400?? no recibe parametros y devuelve un parametro entero.

Cómo prodria hacerlo?

Connection connection   = null;
        try{


Class.forName("com.ibm.as400.access.AS400JDBCDriver");

                         connection = DriverManager.getConnection
("jdbc:as400://xxx.x.x.xx","user","pass");
        }
        catch(Exception e)
        {e.printStackTrace();
         }
        CallableStatement cst = connection.prepareCall("{? = call
TRAEFEC2}");
        cst.registerOutParameter(1,java.sql.Types.INTEGER);
        cst.execute();
        System.out.print(cst.getInt(1));

/// se queda en el execute , que puedo hacer?

Technical Details

Message-ID: <1161893420.447637.179770@h48g2000cwc.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!h48g2000cwc.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1116f3,692a6e7266fe892,start
X-Google-Attributes: gid1116f3,public
X-Google-Language: ENGLISH,ASCII
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!h48g2000cwc.googlegroups.com!not-for-mail
From: "Yamilé" <yamiilee@gmail.com>
Newsgroups: es.comp.lenguajes.java
Subject: As400
Date: 26 Oct 2006 13:10:20 -0700
Organization: http://groups.google.com
Lines: 25
Message-ID: <1161893420.447637.179770@h48g2000cwc.googlegroups.com>
NNTP-Posting-Host: 200.90.16.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1161893426 20400 127.0.0.1 (26 Oct 2006 20:10:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 26 Oct 2006 20:10:26 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 ISASERVER2004
Complaints-To: groups-abuse@google.com
Injection-Info: h48g2000cwc.googlegroups.com; posting-host=200.90.16.4;
   posting-account=nBphTw0AAABchv641_YeWN3TpLukm4IH