Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Question on FileAid/Data Solutions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: Question on FileAid/Data Solutions
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Sat Nov 24, 2012 6:42 pm    Post subject: Reply to: Question on FileAid/Data Solutions
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    Post subject: Reply to: Question on FileAid/Data Solutions
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Sun Nov 25, 2012 2:23 pm    Post subject: Reply to: Question on FileAid/Data Solutions
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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us