Year in Date or Timestamp value is not in the correct range (C G D F).
Hi All, I am getting the above error when trying to write the control format of a subfile. The DDS is coded as follows: A O_ESD L O 9 70DATFMT(*MDY) A MAPVAL(('01/01/40' *BLANK)) Not too sure what the MAPVAL will do as I dont think it can ever...
Hi All, I am getting the above error when trying to write the control format of a subfile. The DDS is coded as follows: A O_ESD L O 9 70DATFMT(*MDY) A MAPVAL(('01/01/40' *BLANK)) Not too sure what the MAPVAL will do as I dont think it can ever...
0 pts.
Performance issue
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method...
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method...
compile commands in RPG
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can i achieve...
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can i achieve...
souce file listing
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File...i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me...
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File...i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me...
SQL Function to return triggered update columns?
We need to retrieve the code that defines a trigger. Not just the code of the trigger(systriggers.action_statement) but the full create statement. I think we have all the elements except for the list of columns in the UPDATE OF clause. This information can be retrieved as follows: SELECT...
We need to retrieve the code that defines a trigger. Not just the code of the trigger(systriggers.action_statement) but the full create statement. I think we have all the elements except for the list of columns in the UPDATE OF clause. This information can be retrieved as follows: SELECT...
function not found - 2 questions
I wrote a function to change a date in character *USA format to *ISO character format. There is a lot of data to insert and all the dates are in *USA format rather than ISO format. The function is created but running the statement, I am told the function does not exist. Why isn't the function...
I wrote a function to change a date in character *USA format to *ISO character format. There is a lot of data to insert and all the dates are in *USA format rather than ISO format. The function is created but running the statement, I am told the function does not exist. Why isn't the function...
Prompting for and passing partial search criteria to queries
I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME)...
I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME)...
AS400 Console
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to disconnect it...
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to disconnect it...
Number of records in the Flat file
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
Physical / Logical file definitions
Can a logical file have fields that differ in definition of type than the physical? I've got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 21 25 FLD3 P 11 2 26 31 Will...
Can a logical file have fields that differ in definition of type than the physical? I've got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 21 25 FLD3 P 11 2 26 31 Will...
Can not figure out this error message
I am creating a table and tring to insert headings into it but I keep getting this one error and I just can not figure it out. Please help if you can. The first statement is: "create table qtemp/rrlib (hdgs char (3000 ) not null with default" Then my insert statement: "insert into qtemp/rrlib...
I am creating a table and tring to insert headings into it but I keep getting this one error and I just can not figure it out. Please help if you can. The first statement is: "create table qtemp/rrlib (hdgs char (3000 ) not null with default" Then my insert statement: "insert into qtemp/rrlib...
Passing variables in SQL
I am writting a CL program that will create and update a table. I am using the command 'runsqlstm'. I am able to build the table but when I try to populate it I am having a problem. I am using the following statement 'insert into qtemp/rrtemp values (&rec). SQL will not process a CL variable. It...
I am writting a CL program that will create and update a table. I am using the command 'runsqlstm'. I am able to build the table but when I try to populate it I am having a problem. I am using the following statement 'insert into qtemp/rrtemp values (&rec). SQL will not process a CL variable. It...
Sql
When I execute this Sql command. I get an error "Column BASEDATA1 not in specified tables." I have a field in IN$FPS00 that I want to include in 'where' condition and update the rest of the fields in this file. Field Basedata1 is in the table. UPDATE IN$FPS00 SET I@R01 = Sum(BaseData1) WHERE...
When I execute this Sql command. I get an error "Column BASEDATA1 not in specified tables." I have a field in IN$FPS00 that I want to include in 'where' condition and update the rest of the fields in this file. Field Basedata1 is in the table. UPDATE IN$FPS00 SET I@R01 = Sum(BaseData1) WHERE...
Locate DB2 files on the iSeries
Henry wrote in with this question recently: "I work with Window-based platforms and know nothing about the iSeries. I need to locate DB2 files on the iSeries and copy or export them to a Windows XP machine where the data will be used with another application. Also, somewhere in the process, I...
Henry wrote in with this question recently: "I work with Window-based platforms and know nothing about the iSeries. I need to locate DB2 files on the iSeries and copy or export them to a Windows XP machine where the data will be used with another application. Also, somewhere in the process, I...
Issuance of CREATE ALIAS
Inna wrote in with this question recently: "Will the issuance of CREATE ALIAS statement lock the actual file member?" Do you know? -- Deb Tart, associate editor
Inna wrote in with this question recently: "Will the issuance of CREATE ALIAS statement lock the actual file member?" Do you know? -- Deb Tart, associate editor
System Setting For Created Libraries
Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.
Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.
using QDBRTVFD to find SQL view create statement
Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer's libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and...
Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer's libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and...
Mainframe to SAP
Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...
Hi, I'm a cobol programmer working on Mainframes with a work exp. of 2 yrs. I've worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...
FTP
When I transfer a file (FTP) from one system to another using Get command numeric data comes as junk. Does anyone know how I can retrieve numeric data ? Thanks
When I transfer a file (FTP) from one system to another using Get command numeric data comes as junk. Does anyone know how I can retrieve numeric data ? Thanks
Retrieving Job Info
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than one job out there (1...
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than one job out there (1...
