- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to set a variable during reloading data
hi
i create a variable (v_max_date) . the purpose of this is to hold the max date of the current table,
since i did an incremental load , i need this variable for the WHERE close.
i was thinking that every time the table is finish loading to Resident the table like this:
(
load
MaxString (Date) as maxdate
Resident Failures;
)
Now i want to make a variable to hold this maxdate for next time using.
how do i do it ?
thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi Sharon,
try this out.
load
MaxString (Date) as maxdate
Resident Failures;
Let v_max_date = peek('maxdate');
I hope this helps.
Deepak
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
It works perfectly !!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi sharon,
doo verify the post , it helps other to know that the issue has been resolved.
Deepak
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
i am new here how do i do that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
On every post , you will see two button , one for correct answer and another one helpful.
If you get a correct answer, click that button. But sometimes you get some helpful answer too in that case click the other one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you