Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Is there a setting for date fields coming out of SQL Server that can be set differently for different users?


Debra Waybright

Recommended Posts

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 = PRINTONLY

SET ASNAMES = ON

TABLE FILE ETL_PROCESS_LOG

SUM 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_DATE

END

-RUN

-READFILE HOLD_MAX_DATE

-DEFAULTH &DATA_AS_OF_DATE='';

-SET &&DATA_DATE = EDIT(&DATA_AS_OF_DATE, '99/99/9999');

-RUN

This is what &&DATA_DATE looks like for everyone else:

06/28/2023

For me, I get:

20/23//06/

Ideas?

Link to comment
Share on other sites

Can you compare the output of this report if you run it vs. other users running the same report?

SET HOLDLIST = PRINTONLY

SET ASNAMES = ON

TABLE FILE ETL_PROCESS_LOG

SUM 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_DATE

END

in addition

please run

WHENCE ETL_PROCESS_LOG MASTER

for both you and another user to see if there's any difference

Link to comment
Share on other sites

Yes whence shows the location in case there are multiple / differfent copies of the master causing this problem

Please run

SET HOLDLIST = PRINTONLY

SET ASNAMES = ON

TABLE FILE ETL_PROCESS_LOG

SUM 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_DATE

END

? HOLD HOLD_MAX_DATE

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...