Login or Register to Ask a Question and Join Our Community


Programming

db2 sql and Java Gui's

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming db2 sql and Java Gui's
# 1  
Old 08-16-2010
db2 sql and Java Gui's
Hi Everyone,

I'm basically trying to rewrite a korn shell script that currently runs and execute a db2 SQL and then it presents the output below to the users. I wonder how I can achieve the same in Java using GUI's. Any advise / comments would be highly appreciated. Thanks.

Code:
  DBNAME     AGENT_ID             AUTHID   APPL_NAME                                APPL_STATUS
---------- -------------------- -------- ---------------------------------------- -----------
T01KATD1                  58105 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  57822 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58315 TKUCOM1 db2jccORB.thread.poo                     UOWWAIT
T01KATD1                  58282 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  57157 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58374 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58216 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58012 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  57887 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58229 TKULAN1 db2jcc_application                       UOWWAIT
T01KATD1                  57854 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58130 TKULAN1 db2jcc_application                       UOWWAIT
T01KATD1                  58222 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58268 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58294 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58228 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58024 TKUPMR1 db2jcc_application                       UOWWAIT
T01KATD1                  58366 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  42333  KDAV   QuestCentral.exe                         UOWWAIT
T01KATD1                  58300 TKUPMR1 db2jcc_application                       UOWWAIT

Moderator's Comments:
Mod Comment After 20 posts you should know [CODE][/CODE] tags
Last edited by pludi; 08-18-2010 at 06:45 AM..
# 2  
Old 08-20-2010
Quote:
Originally Posted by arizah
...
I'm basically trying to rewrite a korn shell script that currently runs and execute a db2 SQL and then it presents the output below to the users. I wonder how I can achieve the same in Java using GUI's. ...
Well, the traditional method would be to use JDBC to connect to and fetch data from DB2, and use Swing to display it in the tabular format.

A more modern approach would be to use Java FX for the GUI part. Java FX is for RIAs; it is Sun's answer to Adobe's Flash/Flex and Microsoft's SilverLight. I am not very clear about the DB connectivity part. You could, of course, still use your JDBC code base with Java FX. But I believe it has inbuilt features for database connectivity. It can atleast interact with Derby quite easily.

tyler_durden
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Python gui or C++ gui or java gui?

python gui or c++ gui or java gui? and when to use etch one? (1 Reply)
Discussion started by: kaja
1 Replies

2. Shell Programming and Scripting

Help in executing the following db2 sql querry in unix

Hi All, Please help me out in executing the following db2 querry in unix db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where CREATE_TS > '2010-11-22 11:00:00.008645' ... (1 Reply)
Discussion started by: dudd9
1 Replies

3. UNIX for Dummies Questions & Answers

how to capture no. of rows updated in update sql in unix db2

hi, i am a new user in unix..and we have unix db2. i want to capture the no. of rows updated by a update db2 sql statement and redirect into a log file. I've seen db2 -m...but not sure how the syntax should be. The update sql that I'm going to run is from a file... Can you please share... (1 Reply)
Discussion started by: j_rymbei
1 Replies

4. Shell Programming and Scripting

Reading values from a file using DB2 SQL

I have some alphbetical codes in that (1 Reply)
Discussion started by: kavithakuttyk
1 Replies

5. Shell Programming and Scripting

Running Sql scripts accross db2

Hi, I would be really thankful, if anyone could help me out with this,since i am very new to this shell scripting. I have 6 sql scripts that i am trying to run in unix across db2. i want the scripts to be executed as follows, script_1 should be executed first. Then... (4 Replies)
Discussion started by: jnimz
4 Replies

6. AIX

IBM DB2 UDB to SQL Server 2005 Porting

Hi All, Am porting my application from AIX to Windows. As a part of this I need to port the Database in IBM DB2 UDB to SQL Server 2005. Is there any Guide/Doc/Article available on this? How to convert the stored procedures and physical data from DB2 to SQL Server 2005? Thanks in Advance (0 Replies)
Discussion started by: mvictorvijayan
0 Replies

7. Shell Programming and Scripting

running db2 sql and exporting output from ksh scipt

Hi there, I am trying to write a shell script as root on AIX 5.3 where I change user to db2inst1, connect to our db2 database, run a sql select query and export the result of the query to a file. The code I have so far is as follows:- #!/usr/bin/ksh su - db2inst1 -c "db2 connect to... (0 Replies)
Discussion started by: candlino
0 Replies

8. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Hi, I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible. List of queries are stored in a file. For example, I have to run a query like this: Select * from &XYZ where... (0 Replies)
Discussion started by: simhasuri
0 Replies

9. Shell Programming and Scripting

pass input arguements to DB2 SQL script

Hi all, I have a shell script which invoke a sql script using command db2 -tf /home/me/db_housekeep.sql -z /home/me/db_housekeep.log however, this mentioned sql script requires several input arguments, I wonder if one can pass variables from shell script to sql script? thanks! (0 Replies)
Discussion started by: mpang_
0 Replies

10. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Hello, I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh. Here is the snippet. if ; then echo "Begin processing VALUEs" ... (1 Reply)
Discussion started by: jerardfjay
1 Replies
Login or Register to Ask a Question