Horrible days for me because while booting Ubuntu throws an error 'HAL not initialized'. I dont what the hell is that. But had a small google on that then understood it something very important 'Hardware Abstraction layer'
below gives aleast what that means http://packages.ubuntu.com/dapper/hal-device-manager
see the wiki http://en.wikipedia.org/wiki/Hardware_abstraction_layer
But enjoy learning from Linux
Tuesday, February 2, 2010
Creating DDS for Physical File (PF)
Physical file creation in AS400 (DDS)
Physical file is like a Table in the oracle database . Using select statments and RUNQRY its possible to access the table
step1: wrkmbrpdm ( in command line )
F6 option is for creating new DDS,RPG,CL etc
The source file for DDS is QDDSSRC and library for me it is DAVNAV1
Source member is the name of the Physical file and source type is PF( Physical file )
Now we are entering into the DDS creation. We have to follow below sequence
1. File level entries
2. record level entries
3. Field level entries
4. Key field lvel entries
step1:
The Functions(F4 - Prompt )- UNIQUE have used for keyword is used to indicate that the value of the key field in each record in the file must be unique ( duplicate records are not allowed )
step2:
In record row give the Name type - R and also the corresponding optional text also can be mention in the function field
step3:
The fields (analogy columns) can be mentioned in next line
step4:
Key field level entries is the last preceeding with 'K'
The DDS can be saved by typing 'FILE' in the top and enter
Compiling the DDS is easy using the option 14-Compile and errors can viewed through the spool files using 'SA' corresponding to the PF in screen
Entry
Meaning
A
Character
P
Packed decimal
S
Zoned decimal
B
Binary
F
Floating point
H
Hexadecimal
L
Date
T
Time
Z
Timestamp
Notes:
strsql from command
insert into student values ('Naveen',1000,50) 1 rows inserted in STUDENT in DAVNAV1.
Physical file is like a Table in the oracle database . Using select statments and RUNQRY its possible to access the table
step1: wrkmbrpdm ( in command line )
F6 option is for creating new DDS,RPG,CL etc
The source file for DDS is QDDSSRC and library for me it is DAVNAV1
Source member is the name of the Physical file and source type is PF( Physical file )
Now we are entering into the DDS creation. We have to follow below sequence
1. File level entries
2. record level entries
3. Field level entries
4. Key field lvel entries
step1:
The Functions(F4 - Prompt )- UNIQUE have used for keyword is used to indicate that the value of the key field in each record in the file must be unique ( duplicate records are not allowed )
step2:
In record row give the Name type - R and also the corresponding optional text also can be mention in the function field
step3:
The fields (analogy columns) can be mentioned in next line
step4:
Key field level entries is the last preceeding with 'K'
The DDS can be saved by typing 'FILE' in the top and enter
Compiling the DDS is easy using the option 14-Compile and errors can viewed through the spool files using 'SA' corresponding to the PF in screen
Entry
Meaning
A
Character
P
Packed decimal
S
Zoned decimal
B
Binary
F
Floating point
H
Hexadecimal
L
Date
T
Time
Z
Timestamp
Notes:
strsql from command
insert into student values ('Naveen',1000,50) 1 rows inserted in STUDENT in DAVNAV1.
AS400 machine learning
Its very difficult for me to study these IBM (iSeries)machines
http://en.wikipedia.org/wiki/IBM_System_i, but slowly am getting some basic findings .
Two weeks back I got access to one online AS400 machine through internet . So learning RPGLE ,CL and basic commands we can practice in my UBUNTU.
just telnet pub1.rzkh.de
then can start WRKMBRPDM ( work with members)