Debra Waybright Posted June 29, 2023 Share Posted June 29, 2023 We have created a global variable in our space that is pulled from a SQL table and it is in a different format for me than for every other user in the company. I thought it is probably related to my administrator status, but others with admin rights don't have the issue.This is how the global variable is created in the edasprof:SET HOLDLIST = PRINTONLYSET ASNAMES = ONTABLE FILE ETL_PROCESS_LOGSUM MAX.DATA_DATE AS 'DATA_AS_OF_DATE'WHERE PROCESS_NAME EQ 'schedule_DAILY_LOAD'WHERE PROCESS_EVENT_NAME EQ 'End'ON TABLE HOLD AS HOLD_MAX_DATEEND-RUN-READFILE HOLD_MAX_DATE-DEFAULTH &DATA_AS_OF_DATE='';-SET &&DATA_DATE = EDIT(&DATA_AS_OF_DATE, '99/99/9999');-RUNThis is what &&DATA_DATE looks like for everyone else:06/28/2023For me, I get:20/23//06/Ideas? Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted June 29, 2023 Share Posted June 29, 2023 Looks like you are getting the date in a different order - is there any difference in your WebFOCUS user profile ?in addition you might want to use a different way to transform your date from table to variable.What is the format of your DATA_DATE field in the master file? Link to comment Share on other sites More sharing options...
Debra Waybright Posted June 30, 2023 Author Share Posted June 30, 2023 The date field is HYYMDs in the master file. I thought about the user profile, but I didn't see a profile file for my ID in the ibi/profiles folder. Maybe I'm looking in the wrong place? Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted June 30, 2023 Share Posted June 30, 2023 Can you compare the output of this report if you run it vs. other users running the same report? SET HOLDLIST = PRINTONLYSET ASNAMES = ONTABLE FILE ETL_PROCESS_LOGSUM MAX.DATA_DATE AS 'DATA_AS_OF_DATE'WHERE PROCESS_NAME EQ 'schedule_DAILY_LOAD'WHERE PROCESS_EVENT_NAME EQ 'End'ON TABLE PCHOLD AS HOLD_MAX_DATEENDin addition please run WHENCE ETL_PROCESS_LOG MASTERfor both you and another user to see if there's any difference Link to comment Share on other sites More sharing options...
Debra Waybright Posted June 30, 2023 Author Share Posted June 30, 2023 I get the same results as others when I run those. Which is really odd, right? Because the date shows like this for me as well as others:I assume the WHENCE command is just saying, "where is this master file?" It returns the same file path. Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted June 30, 2023 Share Posted June 30, 2023 Yes whence shows the location in case there are multiple / differfent copies of the master causing this problemPlease runSET HOLDLIST = PRINTONLYSET ASNAMES = ONTABLE FILE ETL_PROCESS_LOGSUM MAX.DATA_DATE AS 'DATA_AS_OF_DATE'WHERE PROCESS_NAME EQ 'schedule_DAILY_LOAD'WHERE PROCESS_EVENT_NAME EQ 'End'ON TABLE AS HOLD_MAX_DATEEND? HOLD HOLD_MAX_DATE Link to comment Share on other sites More sharing options...
Debra Waybright Posted June 30, 2023 Author Share Posted June 30, 2023 Again, it gives the same results.WebFocus always finds new ways to confound me! Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted June 30, 2023 Share Posted June 30, 2023 What was the answer - what is the format of output field Link to comment Share on other sites More sharing options...
Debra Waybright Posted June 30, 2023 Author Share Posted June 30, 2023 focus_format="MDYY" Link to comment Share on other sites More sharing options...
Martin Yergeau Posted June 30, 2023 Share Posted June 30, 2023 And do you have same regional settings than others on your computer ?Looks like others are USA (which is MM/DD/YYYY) and you are Canadian/French (which is YYYY/MM/DD) Link to comment Share on other sites More sharing options...
Debra Waybright Posted June 30, 2023 Author Share Posted June 30, 2023 That's a good thought, but not it. My regional settings on my computer are "English (United States)" and the Short date format is mm/dd/yyyy. I think WebFocus just likes messing with me 😅 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now