Accessing AS/400 DB2 physical files with Java
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...
15 pts.
Position to in Single page subfile
Hi I have one PF with Policy No . , Cust. Name and both fields are key fields in PF . I want to use position to for field cust name which is the second key field in PF . So is there any way to do this without creating any Logical file ??????(in single page subfile)
Hi I have one PF with Policy No . , Cust. Name and both fields are key fields in PF . I want to use position to for field cust name which is the second key field in PF . So is there any way to do this without creating any Logical file ??????(in single page subfile)
Merge two Physical Files using Logical File
I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.
I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.
Selecting Fields in Logical File
If you would make a logical file and select only fields you need from a physical file that has 500,000 records it, Would it cause a performance issue when a record is updated in the PF?
If you would make a logical file and select only fields you need from a physical file that has 500,000 records it, Would it cause a performance issue when a record is updated in the PF?
db2/400
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update... Please advice...
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update... Please advice...
CPYTOIMPF - PC .TXT file displaying as 'garbage'
Hi, We are using a simple CPYTOIMPF command to move a Physical file to the IFS in a .TXT format. CPYTOIMPF FROMFILE(S4CMREP) TOSTMF(&TOIMPTF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) Where &TOIMPTF is a IFS Folder & file name. This was...
Hi, We are using a simple CPYTOIMPF command to move a Physical file to the IFS in a .TXT format. CPYTOIMPF FROMFILE(S4CMREP) TOSTMF(&TOIMPTF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) Where &TOIMPTF is a IFS Folder & file name. This was...
Add field without altering Record Format Level Identifier
Hi, Is it possible to alter a file (say adding a new field or deleting a existing field) without altering format level indentifier? if yes? please tell me how? Tanx
Hi, Is it possible to alter a file (say adding a new field or deleting a existing field) without altering format level indentifier? if yes? please tell me how? Tanx
Auto download a .CSV file from network drive
to a AS/400 physical file through a cl program? how can I do this?
to a AS/400 physical file through a cl program? how can I do this?
clearing multple members in a physical file
Does anyone know of a way (or utility) to clear multiple members in a physical file ? i create multiple members for the file on the fly based upon date/time in a cl program. the file is a weekly archive of data from a transaction processor, and i want to clear it and start over on a weekly...
Does anyone know of a way (or utility) to clear multiple members in a physical file ? i create multiple members for the file on the fly based upon date/time in a cl program. the file is a weekly archive of data from a transaction processor, and i want to clear it and start over on a weekly...
Compare physical file data
Hi, I am trying to compare data from two different physical files. Both the files are in the same format but from two different systems. I need a report or a file which compares the data in both the files and report the differences in a report or a physical file. Any toughts on this. I already...
Hi, I am trying to compare data from two different physical files. Both the files are in the same format but from two different systems. I need a report or a file which compares the data in both the files and report the differences in a report or a physical file. Any toughts on this. I already...
Unable to over ride a PF member
Hi, I made a cl program and in it I over ride a pf member, clrpfm then call my rpgle program. I can't write on my member but instead it writes on the primary member and reads it. seems the member that is used is the the primary member and not the member that I over rides.
Hi, I made a cl program and in it I over ride a pf member, clrpfm then call my rpgle program. I can't write on my member but instead it writes on the primary member and reads it. seems the member that is used is the the primary member and not the member that I over rides.
Display only the PFs and the number of records in each PF, from a library
Get the library name from a different user , accept the library name , then send the list of only the Physical files in that library , along with the number of records in each PF , to that user.
Get the library name from a different user , accept the library name , then send the list of only the Physical files in that library , along with the number of records in each PF , to that user.
OPNQRYF
I have 4-fileds on Display File like frdiv(zoned),todiv(zoned),frpr(char),topr(char) all the fields are of size 2 only. I am using a "OPNQRYF" to filter the records froma Physical file (pfdiv), it containes 1,25,000 records . Through this openqryf all the selected records I will copy to a file...
I have 4-fileds on Display File like frdiv(zoned),todiv(zoned),frpr(char),topr(char) all the fields are of size 2 only. I am using a "OPNQRYF" to filter the records froma Physical file (pfdiv), it containes 1,25,000 records . Through this openqryf all the selected records I will copy to a file...
DB2/400 - Why does each Physical File member has its own access path?
why each physical file member has its own access path?
why each physical file member has its own access path?
join logical files
Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks
Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks
Search in a Physical file
How can search for a particular string in physical file when there is not any primary key in physical file. There is not any information about the field name and field structures also.. e.g. like we have to search for "anshu" in a PF but we dont have ay idea about the feilds in the PF. PF doesnot...
How can search for a particular string in physical file when there is not any primary key in physical file. There is not any information about the field name and field structures also.. e.g. like we have to search for "anshu" in a PF but we dont have ay idea about the feilds in the PF. PF doesnot...
Problem in CCSID converting
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...
Unable to override a PF member
Hi, I am trying to override a physical file using CL. The CL program is being called by a CBLLE program. In the CBLLE program, I want to process the overridden member.But,all the processing is going on the first member only.It looks like as soon as the CL program terminates DLTOVR gets executed...
Hi, I am trying to override a physical file using CL. The CL program is being called by a CBLLE program. In the CBLLE program, I want to process the overridden member.But,all the processing is going on the first member only.It looks like as soon as the CL program terminates DLTOVR gets executed...
Not able to override a database file in CL
Hi, I am trying to override a physical file using CL. But,when I go and delete the override, I get an exception that it was never overriden. :( Any help will be highly appreciated
Hi, I am trying to override a physical file using CL. But,when I go and delete the override, I get an exception that it was never overriden. :( Any help will be highly appreciated
