Use Dynamic Create Table Command in Stored procedure
Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. Thanks
Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. Thanks
200 pts.
Upload to AS400 DB file
Hi I am not so proficient in programming and i am looking for a way to upload an excel sheet into a database file (with same columns as in m excel) on the as400. I tried to FTP, but i goes in as a flat file. Various other FTP options using FDF etc have failed. Any suggestions ? Thanks Raman
Hi I am not so proficient in programming and i am looking for a way to upload an excel sheet into a database file (with same columns as in m excel) on the as400. I tried to FTP, but i goes in as a flat file. Various other FTP options using FDF etc have failed. Any suggestions ? Thanks Raman
ALDON
Hi, I would like to know...Is it possible to checkout the same object by 2 developers?? If yes then............. How ALDON maintains Multiple Checkouts of the same object???? Thanks, Rama Krishna
Hi, I would like to know...Is it possible to checkout the same object by 2 developers?? If yes then............. How ALDON maintains Multiple Checkouts of the same object???? Thanks, Rama Krishna
Copying Spoolfiles
Hi, I would like to know, How to copy spoolfiles from one AS400 machine to another AS400 machine? Thanks in Advance Rama Krishna
Hi, I would like to know, How to copy spoolfiles from one AS400 machine to another AS400 machine? Thanks in Advance Rama Krishna
V5R3 to V5R4
my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...
my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...
Optimizing/Indexing to find last transaction
I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...
I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...
AS400 PRINTER FONTS
I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don't have printed documentation on site, and I seem to be...
I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don't have printed documentation on site, and I seem to be...
Problems eliminating HEX 41 character.
I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP'ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! Potentially...
I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP'ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! Potentially...
Subfile not displaying properly
I am having a problem with my subfile not displaying properly. I my application, I have two scrollable subfiles displayed. The user can select several vendors and then display a list of checks sent to that vendor in a sequential manor (meaning if the user presses enter, the next vendor selected?s...
I am having a problem with my subfile not displaying properly. I my application, I have two scrollable subfiles displayed. The user can select several vendors and then display a list of checks sent to that vendor in a sequential manor (meaning if the user presses enter, the next vendor selected?s...
Trying to publish a Webfacing Project
Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...
Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...
Sorting out missing out
I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???
I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???
CL code to work on a spoolfile
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don't want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. So...
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don't want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. So...
AS400 disk initialize info
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...
Count days between 2 dates
I wish to, using query count the number of days between 2 dates, the dates are in YYYMMDD format but I presume I'll need to convert the dates to Julian first to allow the caculation. Can anyone help?
I wish to, using query count the number of days between 2 dates, the dates are in YYYMMDD format but I presume I'll need to convert the dates to Julian first to allow the caculation. Can anyone help?
Programming with arrays
Let's say I have 10 arrays, each with 10 elements. I'm trying to delete any array that does not have at least one element that is found in the other arrays - the arrays that remain should have at least one element that is common to all of them. What's the best way to tackle this using RPG IV...
Let's say I have 10 arrays, each with 10 elements. I'm trying to delete any array that does not have at least one element that is found in the other arrays - the arrays that remain should have at least one element that is common to all of them. What's the best way to tackle this using RPG IV...
problems with infsr(*PSSR) and callp
I have a program in which I specify infsr(*PSSR) on a file. This program uses the callp command to call another program which in turn uses the callp to call another program. In this third program, if an error occurs on an IO command on a file that is different than the one upon which I specified...
I have a program in which I specify infsr(*PSSR) on a file. This program uses the callp command to call another program which in turn uses the callp to call another program. In this third program, if an error occurs on an IO command on a file that is different than the one upon which I specified...
QSPOLJBQ - API
I am using QSPOLJBQ (open list of job queues) API to generate a list of all job queues on the system. Need help to use this API.. All I get is "Receiver value too small to hold result." (MCH1210). But the help is not enough to resolve. I tried changing the parameters in many ways. Still I end up...
I am using QSPOLJBQ (open list of job queues) API to generate a list of all job queues on the system. Need help to use this API.. All I get is "Receiver value too small to hold result." (MCH1210). But the help is not enough to resolve. I tried changing the parameters in many ways. Still I end up...
Deleted files
WE have a PF file that got deleted, we don't do job logs unlwss there is a problem...is there anyway to tell who deleted it? Also for in the future, what is the best way to be able to track deletions? We have 9 people that have all obj authority. Also is it possible that the file could get deleted...
WE have a PF file that got deleted, we don't do job logs unlwss there is a problem...is there anyway to tell who deleted it? Also for in the future, what is the best way to be able to track deletions? We have 9 people that have all obj authority. Also is it possible that the file could get deleted...
How can I find on which files a program has been attached as an external trigger?
I have a "generic" rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin
I have a "generic" rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin
SQL
I have a beginner SQL question. I'm new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...
I have a beginner SQL question. I'm new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...
