14 күн бұрын
21 күн бұрын
21 күн бұрын
21 күн бұрын
21 күн бұрын
21 күн бұрын
21 күн бұрын
21 күн бұрын
28 күн бұрын
28 күн бұрын
28 күн бұрын
28 күн бұрын
28 күн бұрын
Пікірлер
@ViratxDoodle 6 күн бұрын
Hey, Why is your website not working?
@AS400andSQLTricks 5 күн бұрын
Yes. There is some issue in migration from Google domains to the squarespace. I did all the dns settings that were asked by the Google support but still it's not working. Please wait for sometime. I will probably find some solutions for this soon and will update everyone on this. The Google domains and squarespace migration deal becomes a blunder for my website. I wrote mail to the Squarespace support team and waited for their response. Thanks for asking. I will update u soon.
@AS400andSQLTricks 4 күн бұрын
My website www.as400andsqltricks.com is accessible now.
@ViratxDoodle 4 күн бұрын
Thanks for the update, it's working indeed. :)
@tahirm09 6 күн бұрын
good
@tahirm09 6 күн бұрын
Good
@tahirm09 13 күн бұрын
good
@mathewk6932 13 күн бұрын
Create video on WRKQRY
@AS400andSQLTricks 12 күн бұрын
kzbin.info/www/bejne/i5bRY2luhdyom68
@deepakpatidar7219 17 күн бұрын
Good 👍
@tahirm09 17 күн бұрын
Good
@tahirm09 18 күн бұрын
good
@tahirm09 22 күн бұрын
Good
@tahirm09 23 күн бұрын
Excellent !!!
@tahirm09 23 күн бұрын
good
@rafaeleduardomantillamarin8588 Ай бұрын
Thank you very much for these As400 tricks, interesting and useful!
@rockfighter9974 Ай бұрын
Thank you
@sachinvithubone4278 Ай бұрын
Good
@sachinvithubone4278 Ай бұрын
When we can use sflnxtchg can you let's know.
@AS400andSQLTricks Ай бұрын
If the SFLNXTCHG indicator on so in the subsequent processing the READC will get that changed record. Also the records can be updated for errors and if no errors are found then they can be processed. As the readc loop updates for errors it updates each subfile change record with the SFLNXTCHG indicator on and that allow the update loop to use the READC to get the records again.
@ravikumars9697 Ай бұрын
Write code also
@AS400andSQLTricks Ай бұрын
You may find long coding videos in my channel also. This is a short video to give a brief info. Thanks for watching my videos.
@SuryaMouni3394 Ай бұрын
Why we eval with PTR1: C 10? to get the DATA value
@AS400andSQLTricks Ай бұрын
data at the address that pointer variable holds
@sachinvithubone4278 Ай бұрын
Small question answered video gain the knowledge. Thank you
@AS400andSQLTricks Ай бұрын
Glad to hear it!
@firedancers1216 Ай бұрын
Do we have any sftp related example, like how interface xml , json or csv files to sftp server thanks
@Drakula840 Ай бұрын
Is there any way to contact you
@AS400andSQLTricks Ай бұрын
Please ask your question here
@Drakula840 Ай бұрын
@@AS400andSQLTricks macro can work on subfiles? I have tried on subfile project...it is not able select last record & this able to select only last page of first record but while we recording a macro..we select last record but while it's playing it's not selected it
@Drakula840 Ай бұрын
@@AS400andSQLTricks please make a video on halt indicator
@Drakula840 Ай бұрын
Thank you for the topic
@rajrani7873 Ай бұрын
🎉🎉🎉
@rajrani7873 Ай бұрын
👍🏻👍🏻👍🏻👍🏻✌🏻✌🏻☺️
@mathewk6932 Ай бұрын
What are the macros in as400?
@AS400andSQLTricks Ай бұрын
will do a video on this.
@mathewk6932 Ай бұрын
@@AS400andSQLTricks thanks for quick reply
@AS400andSQLTricks Ай бұрын
@@mathewk6932 video is on the channel now.
@mathewk6932 Ай бұрын
@@AS400andSQLTricks thank you so much
@Jimi-bx3xf 2 ай бұрын
Sourcefile of the program?
@prakashp4773 2 ай бұрын
I am getting a error null value not allowed in column
@banavathnaresh7048 3 ай бұрын
Hi bro i need notes on the stored procedure in db2
@maxsams7479 3 ай бұрын
Thank you!!
@mathewk6932 3 ай бұрын
Is there any way to find the job, if we know the program name which being used I side the job ?
@mathewk6932 3 ай бұрын
Hi Please consider scenario like how *PREDECER JOB and *SECCER works in job scheduler
@avijit616 3 ай бұрын
Not understanding anything ☹️
@Sibongukwanda 4 ай бұрын
Hi, i woud like to restore these logs from tape from a sav21 backup..how can i do that?
@rockfighter9974 4 ай бұрын
Hi Sir, Hope you are doing well! I need your some help in IL - IBM access client solutions query about. Can you give me your contact number please Thank you!
@SivaSubramanaiamR 5 ай бұрын
Hi Sir I'm Siva Subramaniam, I recently completed my undergraduate degree in 2023 and possess a solid understanding of AS400, thanks to the knowledge inherited from my father. Despite my expertise, I am currently experiencing challenges in finding job opportunities for freshers in this field. I am struggling to connect with the right people who can guide me in the right direction. Is there a possibility for a fresher like me to secure a position in the AS400 domain in the year 2024?
@udtu7825 5 ай бұрын
Hi, when I try this I'm always seeing 1 result set processed. Not getting 1 result set available. Could you let me know what I'm missing?
@KevinLoughran-yx3tl 5 ай бұрын
Thank you, just what I was looking for.
@Jimi-bx3xf 5 ай бұрын
I need to reproduce a runquery that create a spoole file with data information but in a flat file for csv format: separation by ; have you already done this? in a rpg program so to replace the runqry you will call the program that will create the flat file in csv format
@miguelowada 5 ай бұрын
how to obtain a report of all the objects by as400 libraries and transfer it to an excel file
@MaryChristy-yj4sb 6 ай бұрын
My save file is present in WRKOBJ, But not while i give DSPSAVF. Kindly help
@paulharkins4866 6 ай бұрын
Fantastic !!! Make more IBM i videos
@AS400andSQLTricks 6 ай бұрын
More to come!
@paulharkins4866 6 ай бұрын
Fantasitic help to me !!!
@abdoelmoslem 6 ай бұрын
Good job, thank you.
@user-gd7es8tj9q 7 ай бұрын
How you created a member qna41a in wrkmbrpdm
@rishi280876 7 ай бұрын
very nice compilation of basic AS400 questions. Thanks!
@rufinocepedavalentin2911 7 ай бұрын
i need to get program name from a running CLP , like this: JZLEXAMPLE.CLP invoke JZLEXAMPLE.SQLRPGLE this name i need: JZLEXAMPLE.CLP
@levedia 7 ай бұрын
Too long the pc prompt Isnt there a faster way ? Im planning to automate the savf in the as400. What if i just put it in the IFS and then from there drag and drop to the pc ?
@Yaroslav_Osipovich 7 ай бұрын
please add subtitles😢
@higiniofuentes2551 7 ай бұрын
As is used here what is the advantage over creating a view? Or create a user functions or procedure? Thank you!
@higiniofuentes2551 7 ай бұрын
Thank you for this very useful video!
@Sonu-fo9gv 7 ай бұрын
Thank you for sharing your knowledge! I have a doubt, after changing the record capacity do we need to compile any program or anything else needs to be done?