OLE DB using Library List
Hi,Do any one use OLE DB to connect to iSeries?Is OLE DB capable of using Library List provided by Job Description?Because when I used it, I have to specify the library name / schema and object name.Please advice...Thank you
View Answer
| Feb 20 2008 11:49 PM GMT
| asked by
TG
AS/400, DB2, DB2 universal database
Cannot end RGZPFM on V5R4 (Journaled file)
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I...
View Answer
| Jan 12 2008 8:22 PM GMT
| asked by
AS400DBA
ENDJOB, RGZPFM, V5R4
bi-directional data synchronization on System i for db2 databases
I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?
View Answer
| Dec 24 2007 5:46 PM GMT
| asked by
Aroyzen
DataPropagator, System i, DB2 universal database
Backward compatibility on OS level V4R4 to V4R3
Have a question on backward compatability. Currently we moved some historical JD Edwards data that was on an AS/400 running OS400 V4R5 to a machine running V4R4. Now, we want to move this to another AS/400 that is running V4R3. Now, from V4R5 to V4R4 we havd no problems. I'm not sure if we can take...
View Answer
| Jul 3 2007 4:11 PM GMT
| asked by
sysop
DB2 universal database, RPG, DataCenter
Source Modified User
Hi All,If 4 users works on in same library in one source file, How could we know which user has modified a source?ThanksReddy
View Answer
| Jul 2 2007 5:25 AM GMT
| asked by
NarasimhaReddy
AS/400, Application development, Backup & recovery
AS400
hi,i want to know about the answers of these questions..1.)If any data has been deleted from the PF then how can we recover that and what are the limitiations for that.2.)If in run time user want to choose the Access Path of a PF then how can it be possible.
View Answer
| Jun 20 2007 2:50 PM GMT
| asked by
AS400person
AS/400, Application development, Backup & recovery
Excel Data Transfer Add In
I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the...
View Answer
| Jun 19 2007 4:19 PM GMT
| asked by
Joe92506
AS/400, DB2 universal database, Printing
Client Access Data Transfer
I am trying to export a demand report to excel using Client Access Data Transfer. The demand report has been saved in the outque (see below). From what I understand the data to and from the iSeries must be either a database table or source physical file. How do I convert the saved report to a...
View Answer
| Jun 19 2007 11:50 AM GMT
| asked by
Joe92506
AS/400, DB2 universal database
Converting from System 36 to iSeries V5R4
I've been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4.I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could'nt find anything.Does anyone have something I can use - something like the...
View Answer
| Jun 18 2007 4:25 AM GMT
| asked by
JohnDavid
AS/400, Application development, Backup & recovery
Select last 3 transactions
HelloCan someone help me to put together an SQL statement to select the last 3 transactions from a transaction file.In TransactSQL I would do something like this:select top 3 CustID, TransDate, Amountfrom Transwhere CustID= '12345'order by TransDate desc.I believe there must be a more effcient way...
View Answer
| May 22 2007 6:54 AM GMT
| asked by
SuhelAC
DB2 universal database, PC/Windows Connectivity, Data analysis
URGENT!!! file field decoder generated on AS/400
REALLY URGENT!!!!!!!!!!!!!!!!!!!!!How can i view the contents of a packaged field?I send an example of the chain. I need to visualize the contents of the little squares:5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO...
View Answer
| May 21 2007 11:15 PM GMT
| asked by
onasis
AS/400, Application development, DB2 universal database
Tracking Changes to Files
Requirement:-To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee)Could you please suggest a good approach for this?I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any changes to...
View Answer
| May 11 2007 5:44 AM GMT
| asked by
AyeYes400
AS/400, Application development, Backup & recovery
Question on LoadAll Subfile.
Hi,How to load more than 9999 records in the case of loadall subfile??? And i don't want delete previously loaded records.Thanks,Rama Krishna
View Answer
| May 7 2007 1:58 AM GMT
| asked by
meesala
AS/400, Application development, CLP
Error in a Group of Called Programs
Hi,I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this???Thanks...
View Answer
| Apr 26 2007 12:16 AM GMT
| asked by
meesala
AS/400, Application development, Backup & recovery
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 executed...
View Answer
| Apr 7 2007 12:52 AM GMT
| asked by
priyaranjanltcp
Project management, AS/400, Application development
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,...
View Answer
| Apr 3 2007 12:03 AM GMT
| asked by
MODMOD
AS/400, Application development, DB2 universal database
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 any...
View Answer
| Mar 28 2007 9:03 AM GMT
| asked by
selectsoft
AS/400, Application development, DB2 universal database
Question on Workfile
Hi,Please could any one help me getting answers to these Questions....What is the diff. between Workfile and PF?How do u create a WorkFile in RPG or CL.What are the advantages of WorkFile over PF?ThanksRama
View Answer
| Mar 26 2007 6:01 AM GMT
| asked by
meesala
AS/400, DB2 universal database, RPG
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???
View Answer
| Mar 11 2007 1:14 AM GMT
| asked by
meesala
Application development, DB2 universal database, RPG
Sorting out missing records.
Suppose i have 2 database files.one with 250 records and another with 350 records.There are some common records in both files. How to get the missing records??Is this possible with CPYF command. If yes???Please explain me how to get this. or Is there any other to achieve this.Thanks and RegardsRama...
View Answer
| Mar 2 2007 3:51 AM GMT
| asked by
meesala
DB2 universal database
