IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Question on FileAid/Data Solutions


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Virinchi.Ravi

New User


Joined: 14 Sep 2012
Posts: 2
Location: India

PostPosted: Sat Nov 24, 2012 12:28 am
Reply with quote

Hi,

Good Morning. I am working on the FileAid Suite of tools provided by Compuware for ETL processing. As part of the solution, we have to Privatise Name fields and this is where I ran into some challenges. Below is the Scenario :

I have a flat file with below fields :

Code:

...
01 FULL-NAME     PIC X(50).
...


It holds first name, Middle name and last name separated by Spaces.
For eg,

SACHIN R TENDULKAR
SUPER STAR RAJNI
FILE AID

Each word (token) in this field has to be translated. Output can be like

SHANE X WARNE
A B C
HTML ABC

I am using FileAid/Data Solutions 4.4. The Challenge is Splitting the name into three tokens.

I know that we can write a COBOL program and using Unstring we can split them. But I cannot write code here.

Do you know if FA/DS has any Built in String function to achieve this ?

Thanks,
Virinchi
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Sat Nov 24, 2012 6:42 pm
Reply with quote

Since you have the product, you have the documentation. Have you tried looking there? Using PF1? Registering for the Compuware support site and searching/asking there?
Back to top
View user's profile Send private message
Virinchi.Ravi

New User


Joined: 14 Sep 2012
Posts: 2
Location: India

PostPosted: Sun Nov 25, 2012 1:47 pm
Reply with quote

Thanks for your reply. I posted here only as the last option. I read the documentation. As I understood, FileAid/DS does not have such kind of ability . But, I wanted to confirm before concluding.

I posted a mail to Compuware only to find that there is no response. There are no FileAid experts at my site.

I know one way which is not the best option to go with.

(1) Define three Global variables - &FIRST, &SECOND, &THIRD (To store three different words of Full-name)

(2) Scan through the FULL-WORD for 50 times (One time for each Character)

(3) If a Space occurs, append all characters as a word and Store in one of the 3 variables based on the Occurrence of the Space.

Since FileAid Does not have any String Function/Looping facity, nearly 250 sets of 'Selection Criteria' and 'Change criteria' have to be defined.

I know that this option will work, but I was looking for any other option that I am not aware of.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Sun Nov 25, 2012 2:23 pm
Reply with quote

You should try to register for their site. There may be discussion groups there where someone has done something similar.

It is a holiday weekend in the US, so not as many people as usual will be looking here. Try again late Monday/early Tuesday, perhaps.

If you get nowhere, there's always "do it in a program..."
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Adding a header when change data DFSORT/ICETOOL 6
No new posts Selective extract of multi-record-typ... SYNCSORT 4
No new posts Expected data is not coming up on Fir... CICS 2
No new posts Sort w/OUTREC Question DFSORT/ICETOOL 2
No new posts Data for newly added fields not displ... IMS DB/DC 6
Search our Forums:

Back to Top