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.

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)

JOB SATISFACTION

Let me  brief  this word 'job satisfaction'

100 percentage saturation in the word 'JOB' is achievable or not ?  I would say horribly unanswerable question. 

Most of the students( case of Me too ) reaching  MNC s and sells their brain to silly things ..simply silly things or keeps most of the time  their brain in switch off state.

Sometimes I feel salary matters, but someone like me coming from Electronics background and trying to expertise in MS excel or something , pains me why i have studied 4 years in Btech. What is the meaning of Btech ....

But of course I am sure that  there are solution to overcome this by selecting good career path and doing something effective or good .But I am not sure whether it is achievable for me. May this is because I like this idle state more than going for a risk.

If you are doing something with Full mind and getting preferable outcome and benefit , then its a state of satisfaction or saturation. ( This is my definition for satisfaction )

May I show you some cases of this :

1. Doing something with full mind and not getting enough outcome ( really discouraging feeling )

2. Not getting full mind to do thing,  may be because  the feeling of nothing gains from present work, can not expertise in this field or very poor idea on the present work etc

Sometimes I feel why  I can't find out the correct path .. what I know ? Nothing I know to do myself . But I have some in built abilities , may be those can not make much output as money .. but I would like to say those works I likes more .   

But I am hearing lot of advise like if we try to put  full mind and effort , it will produce more outcome and satisfaction .. try to expertise in the current working field. But I am not sure that is correct or not.

Job satisfaction rate  depends on individual, but much he utilize his brain and effort on his favorite area  even though  the outcome is less ..its somewhat manageable otherwise mind will not set anywhere .. that is what my experience 

I will never ever leave my interesting areas and always try to learn something new ... at least I will keep this as  my hobby  that may increase my mind satisfaction level.