mkdb.file and create.file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
arun@sinmax
Premium Member
Premium Member
Posts: 13
Joined: Tue Jun 14, 2005 6:25 am

mkdb.file and create.file

Post by arun@sinmax »

gurus,
can anybody tell me what mkdb.file and create.file will do in the hashed file context.what kind of hashed file both the command will create?

my second question is what are the problems in loking up a database table not a hashed file?

please put some light on the above question.

thanks in advance.
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

Hi

1.mkdb.file will create a hashed file in the specified directory( you need to give the path of the directory where you want to create the hasehd file)


CREATE.FILE will create a hashed file in the Project directory.

2.Looking up a hashed file is always faster than looking up a database table.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

A couple of teensy corrections... :wink:

1) It's 'mkdbfile' with no dot in it.

2) CREATE.FILE is use in an 'Account' which is typically synonymous with the current Project.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

Thanks Craig. I totally overlooked the mkdbfile. :)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: mkdb.file and create.file

Post by ray.wurlod »

arun@sinmax wrote:gurus,
can anybody tell me what mkdb.file and create.file will do in the hashed file context.what kind of hashed file both the command will create?

my second question is what are the problems in loking up a database table not a hashed file?

please put some light on the above question.

thanks in advance.
1. Exactly the same for the same parameters. Only the location differs.
2. Speed, mainly.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply