Solved

Use of "TRIM" in DDS Logical File declaration

Posted on 2008-10-01
1
774 Views
Last Modified: 2012-05-05
When building a Logical File Definition using DDS ...

... SST is the SUBSTRING function
0009.00      A            WHOOWNS            I      SST(TLTBLS 26 5)

That's great ... but ...
I need the WHOOWNS field value LEFT SET and LEFT TRIMMED
Because SST(TLTBLS 26 5) actually evaluates to "  XYZ" and "    A" and "   ZA"

How?
0
Comment
Question by:volking
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 27

Accepted Solution

by:
tliotta earned 500 total points
ID: 22620089
volking:

No one else has responded, so I'll do what I can. If I'm wrong, someone's bound to catch it and we'll both learn something.

The answer seems to be "You can't." If I were doing this, I'd probably create a SQL VIEW with a DDL statement rather than try to get it done with DDS.

However, it might help if you describe the business use for this. Usually, the reason for going with DDS would be to support a compiled language such as COBOL, RPG, C, etc., where native I/O was a requirement. But those languages already supply functionality for substrings, left-adjusting, trimming, under more precise control.

Can you provide the environment within which this field definition is needed?

Tom
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AS400 DAYOFWEEK(GENERAL DATE) 12 429
DB2 iSeries Date comparison w/ sysibm.sysdummy1 18 106
Iseries Object Security 5 88
XML response optional elements 12 61
This article was originally published on Monitis Blog, you can check it  here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sour…
This article was originally published on Monitis Blog, you can check it  here .   Some years back, I worked as the CTO.  During my tenure, I had a head of IT support reporting to me.  He did his job quite well and had a commendable sense of duty…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question