Jack_Crouch
Well Known Member
We have an AS/400 for our Enterprise Server. I use a file editor utility
called PFE (Passport File Editor). It is like DBU (for those AS/400
folks). In fact... you can simply use the UPDDTA command if you are
desperate.
I use these things for simple one - two record patches. For example...
numerous files get a "blank" record in them. That is records in F0115 (for
example) that have an address number of 0.
Very nice... These records reek unpredictable havoc with applications. I
have had them in F1201, F0101, F4801, etc., etc...
Anyway (I digress). I use SQL for any kind of mass update Cowboy activity.
Point is... our Central Objects are on MS SQL. I am longing for a simple
DB file editor to pull up, poke around, update, add, insert records in files
like F98761, etc. Instead, you are stuck with an unfriendly Query
Analyzer SQL product to do this.
(I say unfriendly because you have to screw around with system catalog files
to simply get field / file lists and such. Compare that with STRSQL or
Sequel on the AS/400... which give you simple F4=Prompts) And writing SQL
for simple things like this is time consuming...
Shirley.... There are tools out there to pop in and around MS SQL....
Does anyone know of any?
AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
called PFE (Passport File Editor). It is like DBU (for those AS/400
folks). In fact... you can simply use the UPDDTA command if you are
desperate.
I use these things for simple one - two record patches. For example...
numerous files get a "blank" record in them. That is records in F0115 (for
example) that have an address number of 0.
Very nice... These records reek unpredictable havoc with applications. I
have had them in F1201, F0101, F4801, etc., etc...
Anyway (I digress). I use SQL for any kind of mass update Cowboy activity.
Point is... our Central Objects are on MS SQL. I am longing for a simple
DB file editor to pull up, poke around, update, add, insert records in files
like F98761, etc. Instead, you are stuck with an unfriendly Query
Analyzer SQL product to do this.
(I say unfriendly because you have to screw around with system catalog files
to simply get field / file lists and such. Compare that with STRSQL or
Sequel on the AS/400... which give you simple F4=Prompts) And writing SQL
for simple things like this is time consuming...
Shirley.... There are tools out there to pop in and around MS SQL....
Does anyone know of any?
AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO