Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us