Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
bjdouglas
Contributor II
Contributor II

Is there a way to shutoff logging temporally within a script

I have an Autogenerate statement within my script:

Iteration:
Let x = ($(vCurYr) - 1996) * 12 + $(vCurMoNum) ;

for y = 1 to $(x)

for z = 1 to $(y)

// trace y=$(y) z=$(z);

load $(y) as Gen_Months, $(z) as Iteration

AutoGenerate 1;

next z

next y

This is what I see in the log

20231105T064900.917-0500 0116 for z = 1 to 23
20231105T064900.917-0500 0121 load 23 as Gen_Months, 1 as Iteration
20231105T064900.917-0500 0122
20231105T064900.917-0500 0123 AutoGenerate 1
20231105T064900.917-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.917-0500 254 lines fetched
20231105T064900.918-0500 0125 next z
20231105T064900.918-0500 0121 load 23 as Gen_Months, 2 as Iteration
20231105T064900.918-0500 0122
20231105T064900.918-0500 0123 AutoGenerate 1
20231105T064900.918-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.918-0500 255 lines fetched
20231105T064900.918-0500 0125 next z
20231105T064900.919-0500 0121 load 23 as Gen_Months, 3 as Iteration
20231105T064900.919-0500 0122
20231105T064900.919-0500 0123 AutoGenerate 1
20231105T064900.919-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.919-0500 256 lines fetched
20231105T064900.919-0500 0125 next z
20231105T064900.919-0500 0121 load 23 as Gen_Months, 4 as Iteration
20231105T064900.919-0500 0122
20231105T064900.919-0500 0123 AutoGenerate 1
20231105T064900.920-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.920-0500 257 lines fetched
20231105T064900.920-0500 0125 next z
20231105T064900.920-0500 0121 load 23 as Gen_Months, 5 as Iteration
20231105T064900.920-0500 0122
20231105T064900.920-0500 0123 AutoGenerate 1
20231105T064900.920-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.921-0500 258 lines fetched
20231105T064900.921-0500 0125 next z
20231105T064900.921-0500 0121 load 23 as Gen_Months, 6 as Iteration
20231105T064900.921-0500 0122
20231105T064900.921-0500 0123 AutoGenerate 1
20231105T064900.921-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.921-0500 259 lines fetched
20231105T064900.922-0500 0125 next z
20231105T064900.922-0500 0121 load 23 as Gen_Months, 7 as Iteration
20231105T064900.922-0500 0122
20231105T064900.922-0500 0123 AutoGenerate 1
20231105T064900.922-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.922-0500 260 lines fetched

This goes on for 54K + lines fetched.

I'd like to temporarily shut logging off for this step.

Any ideas?

Labels (1)
1 Solution

Accepted Solutions
cwolf
Creator III
Creator III

a better way:

Let x = ($(vCurYr) - 1996) * 12 + $(vCurMoNum) ;

t:
load
Gen_Months,
IterNo() as Iteration
While IterNo()<=Gen_Months; 
Load
RecNo() as Gen_Months
AutoGenerate $(x);

View solution in original post

2 Replies
cwolf
Creator III
Creator III

a better way:

Let x = ($(vCurYr) - 1996) * 12 + $(vCurMoNum) ;

t:
load
Gen_Months,
IterNo() as Iteration
While IterNo()<=Gen_Months; 
Load
RecNo() as Gen_Months
AutoGenerate $(x);
bjdouglas
Contributor II
Contributor II
Author

Thank you! This works for what I wanted it to do. A lot fewer lines in the log. I suppose that you can't turn the log off temporarily.