Numbers/Characters

[Guest.Visitor]

Katy, You don't specify which "tool" you are using to accomplish the chain/link. Is it RPG,RPG/LE,Cobol,Query,SQL,etc. RPG: MOVE CHARFLD NUMFLD SQL: From numfile join charfile on digits(numdate)=chardate Query: chardate1 digits(numdate) -then- Select Records: chardate1 eq chardate Bill

[Guest.Visitor]

You take UNIT , and DATE (char fields) and do a MOVE into Numeric fields. Better to do a TESTN before you chain in case you put in non number fields into the numeric fields. TESTN UNIT 67 *IN67 IFEQ *ON MOVE UNIT UNITX 4,0 ENDIF TESTN DATE 67 *IN67 IFEQ *ON MOVE DATE DATEX 8,0 ENDIF c************************************* KEY1 KLIST KFLD UNITX KFLD DATEX

[Guest.Visitor]

I'm investigating the API QVISNDRCV, part of Visual Info/400, and am coming up empty. Can anyone offer any suggestions?

[Guest.Visitor]

I have two files. On one the two key fields are UNIT (character) and DATE (character). I have to chain to another file for more information, using these two key fields. Only, on the second file both UNIT and DATE are numeric. Any ideas how I cope with this? Katy

[J.Wells]

Pam, I might be able to offer a little help. I'll create a new discussion that you can look at. Joe