/tpu question

[Taber, Phil]

Here is how I have done my conversion.  Start with the old dictionary
deffinition and write a QTP procedure to dump the data to a permanent
subfile.  Modify the dictionary, create an empty version of the file and
then write a QTP procedure to reload the file adding the '19'  or 19000000
to the date fields (depending if character or numeric data originally).  The
catch is to test that there is a date in the field.  SO the code is as
follows:

ITEM DATE_FIELD FINAL 19000000 + DATE_FIELD OF SUBFILE1 IF DATE_FIELD OF
SUBFILE1 > 0

Or

ITEM DATE_FIELD FINAL '19' + DATE_FIELD OF SUBFILE 1 IF DATE_FIELD OF
SUBFILE1 > ' '

	
Easier that TPU scripting....

Phil

	-----Original Message-----
	From:	Michel Rioux [SMTP:mrioux%iline.com@interlockp.lubrizol.com]
	Sent:	Monday, January 11, 1999 1:33 PM
	To:	powerhouse
	Subject:	/tpu question

	Hey folks!!!
	 
	Here my problem.....i'm converting data files to inlcude the
century.  My original file had a six digit char date, and now i'm trying to
put the data back in by adding 19 to the existing char's and putting
(nconvert) them in a zoned-u field.  So far so everythings has been working
fine till now.  The file i'm trying to convert now (which was written by
dibol, basic, or cobol...take your pick), has "null's" instead of a date for
certain records.  PowerHouse sees these null as actual characters......it
will not display them, but if i concantanate 19 with the existing date
value, and simply edit the subfile, i see the null values.  Powerhouse knows
there is something there, but doesn't know what it is, and if i do nconvert,
i get data conversion erros.  The best we've come up with is replacing the
null with acutall spaces within TPU.  Now this would work fine if we were
converting these files interactively, but we run a batch job in the middle
of the nite.  Does anybody know how to pass parameters to a edit/tpu command
do such a thing.
	 
	Thanks in advance 
	 
	Michel
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.