Calling a URL length more than 200 from CLP
Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % ” < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its [...]
Answer Question
| February 8, 2010 12:31 PM
AS/400 DB2, CLP, CLPROGRAM, DB2, RPG
Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % ” < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its [...]
Answer Question
| February 8, 2010 12:31 PM
AS/400 DB2, CLP, CLPROGRAM, DB2, RPG
Why does the keyword END is not accepted at the end of a stored proc ?
Hey guys, I have thise error in SQL stored proc. I’m on ISERIES and I use RUNSQLSTM to very my procedure. could you help ? It’s seem I can’t put a END at the end! ——————— 160 AND DUDGCT = CDCODE 161 AND SUBSTRING(CDCEL3,1,4) = ( 162 SELECT CLSTHE FROM [...]
Answer Question
| January 26, 2010 9:03 PM
DB2, iSeries, SQL
Hey guys, I have thise error in SQL stored proc. I’m on ISERIES and I use RUNSQLSTM to very my procedure. could you help ? It’s seem I can’t put a END at the end! ——————— 160 AND DUDGCT = CDCODE 161 AND SUBSTRING(CDCEL3,1,4) = ( 162 SELECT CLSTHE FROM [...]
Answer Question
| January 26, 2010 9:03 PM
DB2, iSeries, SQL
Data transfer from DB2 (AS400) TO SQL SERVER 2005
Data transfer from DB2 (AS400) TO SQL SERVER 2005
Answer Question
| January 25, 2010 11:39 AM
AS/400 data transfer, DB2, DB2 Data Transfer, DB2 to SQL Server Data Transfer, send any detail help please, SQL Server 2005
Data transfer from DB2 (AS400) TO SQL SERVER 2005
Answer Question
| January 25, 2010 11:39 AM
AS/400 data transfer, DB2, DB2 Data Transfer, DB2 to SQL Server Data Transfer, send any detail help please, SQL Server 2005
is there any process to store the data of dataqueue
is there any process to store the data of dataqueue
Answer Question
| January 21, 2010 7:32 AM
AS/400, DB2
is there any process to store the data of dataqueue
Answer Question
| January 21, 2010 7:32 AM
AS/400, DB2
can anybody tell me how to know max sal in db2/400 means in pf
can anybody tell me how to know max sal in db2/400 means in pf
Answer Question
| January 20, 2010 1:07 PM
DB2, DB2/400, PF
can anybody tell me how to know max sal in db2/400 means in pf
Answer Question
| January 20, 2010 1:07 PM
DB2, DB2/400, PF
Domino server R7 and DB2
Hi all, I would like to setup a Domino 7 server and DB2. Our environment has experience seperate server for Domino 7 and DB2 server. Does anyone know that is tht possible to install Domino 7 server and DB2 into one single powerful server? Kindly advise. Thank you.
Answer Question
| January 18, 2010 7:37 AM
DB2, DB2 server, Domino 7, Domino Server
Hi all, I would like to setup a Domino 7 server and DB2. Our environment has experience seperate server for Domino 7 and DB2 server. Does anyone know that is tht possible to install Domino 7 server and DB2 into one single powerful server? Kindly advise. Thank you.
Answer Question
| January 18, 2010 7:37 AM
DB2, DB2 server, Domino 7, Domino Server
DB2 Unload and Load JCL using IBM utility
Hi, Can anyone provide me a JCL to unload and load DB2 tables using IBM utility. I’m new to DB2 and need to unload the Syspunch dataset for a table, as I need to load a the table with data. I just only have the file with the data to be loaded. So I need [...]
Answer Question
| April 19, 2013 2:47 AM
DB2, IBM Mainframe, JCL
Hi, Can anyone provide me a JCL to unload and load DB2 tables using IBM utility. I’m new to DB2 and need to unload the Syspunch dataset for a table, as I need to load a the table with data. I just only have the file with the data to be loaded. So I need [...]
Answer Question
| April 19, 2013 2:47 AM
DB2, IBM Mainframe, JCL
Data Access Layer in RPG
Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a [...]
Answer Question
| January 7, 2010 5:23 PM
DB2, RPG, RPGILE
Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a [...]
Answer Question
| January 7, 2010 5:23 PM
DB2, RPG, RPGILE
DB2 to SQL Server migration
We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or [...]
Answer Question
| April 13, 2010 5:39 PM
DB2, SQL Server migration
We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or [...]
Answer Question
| April 13, 2010 5:39 PM
DB2, SQL Server migration
Need to know the journals within a library or a list of libraries and write it to an outfile
Hi. Is there an easy way to get a list that will provide information on which physical files are being journaled within a library? For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven’t found it, nor have I been able to [...]
Answer Question
| December 2, 2009 2:39 AM
AS/400, AS/400 journaling, DB2, Journal Receivers, Journals
Hi. Is there an easy way to get a list that will provide information on which physical files are being journaled within a library? For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven’t found it, nor have I been able to [...]
Answer Question
| December 2, 2009 2:39 AM
AS/400, AS/400 journaling, DB2, Journal Receivers, Journals
DECFLOAT – Internal Format
Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: “Convert and return a DECFLOAT representation of a number or string representation of a number”, (Appendix A. Writing exit routines). There is an example there: Internal Format DFP Format String Representation D8F77D00000000000C 222C000000001E80 +7.500 They do not explain, how to [...]
Answer Question
| February 1, 2010 2:47 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: “Convert and return a DECFLOAT representation of a number or string representation of a number”, (Appendix A. Writing exit routines). There is an example there: Internal Format DFP Format String Representation D8F77D00000000000C 222C000000001E80 +7.500 They do not explain, how to [...]
Answer Question
| February 1, 2010 2:47 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
db2/400
Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?
Answer Question
| November 4, 2009 12:06 PM
AS/400 simulator, DB2, DB2/400
Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?
Answer Question
| November 4, 2009 12:06 PM
AS/400 simulator, DB2, DB2/400
Procedure Pointer
How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400?
Answer Question
| October 30, 2009 11:38 AM
AS/400, AS/400 Pointers, AS/400 Procedure Pointer, DB2
How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400?
Answer Question
| October 30, 2009 11:38 AM
AS/400, AS/400 Pointers, AS/400 Procedure Pointer, DB2
External DB2 Database link/trigger
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.
Answer Question
| October 29, 2009 10:42 AM
AS/400 database, DB2, DB2/400, i5/OS, V5R4
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.
Answer Question
| October 29, 2009 10:42 AM
AS/400 database, DB2, DB2/400, i5/OS, V5R4
AS/400 file transfer window disappears
as400 file transfer window drops to the bottom never to return.
Answer Question
| October 22, 2009 3:21 PM
AS/400 File Transfer, DB2
as400 file transfer window drops to the bottom never to return.
Answer Question
| October 22, 2009 3:21 PM
AS/400 File Transfer, DB2
Is the new WRKDBF out yet?
Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.
Answer Question
| December 12, 2011 1:51 PM
AS/400, DB2, DB2UDB, i5, iSeries, WRKDBF
Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.
Answer Question
| December 12, 2011 1:51 PM
AS/400, DB2, DB2UDB, i5, iSeries, WRKDBF
STORED PROCEDURE
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on it
Answer Question
| October 21, 2009 5:14 AM
DB2, SQL stored procedures, SQL/400
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on it
Answer Question
| October 21, 2009 5:14 AM
DB2, SQL stored procedures, SQL/400
Ideal memory for DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box.
We are running one instance of DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box. this box is dedicated to Db2. We have 32G of memory. I would like to know what is the ideal amount of memory to be allocated to DB2 and how much for the OS? Also how much of swap space [...]
Answer Question
| October 1, 2009 5:05 PM
DB2, Linux, Linux Box, Memory management
We are running one instance of DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box. this box is dedicated to Db2. We have 32G of memory. I would like to know what is the ideal amount of memory to be allocated to DB2 and how much for the OS? Also how much of swap space [...]
Answer Question
| October 1, 2009 5:05 PM
DB2, Linux, Linux Box, Memory management
DB2 Web Query record count
Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?
Answer Question
| October 1, 2009 3:59 PM
DB2, DB2 Web Query
Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?
Answer Question
| October 1, 2009 3:59 PM
DB2, DB2 Web Query
SQL error
I’ve a cursor to fetch date from DB2/400…When date is stored as 0001-01-01, I get error – Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my [...]
Answer Question
| September 28, 2009 4:57 PM
DB2, DB2/400, SQL error messages, SQLRPGLE
I’ve a cursor to fetch date from DB2/400…When date is stored as 0001-01-01, I get error – Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my [...]
Answer Question
| September 28, 2009 4:57 PM
DB2, DB2/400, SQL error messages, SQLRPGLE
