Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Restarting websphere automatically
Here is the scenario.. I am running an application on websphere which contains ejb and connects to AS/400 database. The database goes down every midnight. The applications works only if i restart the websphere server after the database server is started. Is there anyway i can automatically...- sarr
- Thread
- Replies: 1
- Forum: General e-Business discussion
-
How to identify websphere home?
Does anyone know how to identify websphere home directory?- sarr
- Thread
- Replies: 3
- Forum: General e-Business discussion
-
Rows into Columns
What if there should be difference be listed in the 4th column like newprice-oldprice. Directly doing like this is not working for me- sarr
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Rows into Columns
tlbroadbent, Thanks for your quick reply. This is what i want. You got my vote!- sarr
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Rows into Columns
i have a table like this product | price | status --------|--------| ------ pen | 100 | old pen | 105 | new --------|--------|------- Expect result as :- ----------------- product oldprice newprice ------- -------- --------- pen 100 105 Please note that the...- sarr
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Exit Handler??
DROP PROCEDURE MYLIB.TestErrorHandler; CREATE PROCEDURE MYLIB.TestErrorHandler () LANGUAGE SQL BEGIN DECLARE prodnum DECIMAL(6,0); DECLARE at_end INT DEFAULT 0; DECLARE SQLCODE INT DEFAULT 0; DECLARE not_found CONDITION FOR '02000'; DECLARE c1 CURSOR FOR SELECT DISTINCT (MYPRODNUM)... -
Dynamic Variable
I require the variables to be declared dynamically like this For i = 1 to 20 Dim var & i Next for which i expect output like Dim var1, var2, var3.. Later on, i should use this in my program like, For i = 1 to 20 var & i = "somevalue" Next Could someone help me to build this... -
Building Array Names
I would like to build a dynamic array with dynamic array names like this. myarray1 = array(10,20) myarray2= array(30,40) myarray3= array(50,60) How to build the dynamic array name.. like this. Is it possible using a loop?
