DS code behaving differently in different environment
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Wed Aug 27, 2008 1:57 am
- Location: US
DS code behaving differently in different environment
Hi, I have same DSX in prod and DEV. But while selecting any value from DUAL in prod it is padding some space where as in dev it is not. I can ensure no change in DS jobs. Could someone put any light what could be the issue?
Last edited by s_gsl@yahoo.co.in on Tue Sep 01, 2015 12:35 pm, edited 1 time in total.
Santanu Ghosal
-
- Participant
- Posts: 3
- Joined: Wed Aug 27, 2008 1:57 am
- Location: US
Yes, this is a server job. We are getting this issue while doing a look up (Oracle -- >Hash File-->Transformer) and the field is CHAR(2). Then we tried to simple querying DUAL table to select any value and see the issue is PROD version is adding extra spaces where as DEV is not. I am not sure how can i attach an image here else i can send the screen shot. Anyway, thanks for your help.
Santanu Ghosal
Are the two jobs SELECTing the same database? If not, the basic database settings might be different.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3
- Joined: Wed Aug 27, 2008 1:57 am
- Location: US
'Same' as in exact same database or they are two different databases but set up exactly the same?
Where exactly is this CHAR(2) in your job? I'm more surprised to hear it doesn't get padded with 'an extra space' in DEV than it does happen in PROD. That's the nature of CHAR fields, they automatically pad out to their full size. Parallel jobs have an option to control what character is used for the padding which is why Paul asked his question, Server jobs not so much.
Where exactly is this CHAR(2) in your job? I'm more surprised to hear it doesn't get padded with 'an extra space' in DEV than it does happen in PROD. That's the nature of CHAR fields, they automatically pad out to their full size. Parallel jobs have an option to control what character is used for the padding which is why Paul asked his question, Server jobs not so much.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: