AS/400 administration, AS/400 backup, AS/400 command functions, AS/400 commands, AS/400 database, AS/400 DB2, AS/400 development, AS/400 error messages, AS/400 errors, AS/400 FTP, AS/400 jobs, AS/400 objects, AS/400 performance, AS/400 printing, AS/400 Query, AS/400 security, AS/400 Spool Files, AS/400 Subfiles, AS/400 user profiles, BRMS, CL, CL Program, CL programming, CL programs, CL/400, Client Access, CLLE, CLP, COBOL, DDS, i5, i5/OS, IFS, iSeries, iSeries RPG programming, iSeries V6R1, OS/400, Physical File, PTFs, RPG, RPG ILE, RPG/400, RPGILE, RPGLE, Spool files, SQLRPGLE, Subfile, V5R3, V5R4, V6R1 VIEW ALL TAGS
When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:\Users\mssadmin>sqlcmd -S servername -d databasename-q "EXIT( exec dbo.subprogram)" it retunrs as 0 rows affected. What could be the problem
I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).
I am trying to use the return value of a SQL Restore script executed with SQLCMD, so that my batch script can report on the succes or failure of the restore. I am having difficulty getting the script to return the result of the backup or restore process. Do you have any suggestions? The follwoing...