/* you need a function dberror(int errcode, int line) that displays errors and exits */
void dberror(int errcode, int line)
{
fprintf(stderr,"Error %d on line %d\n", errcode * -1, line);
EXEC SQL
ROLLBACK WORK RELEASE;
exit(1);
}
#define ORACHK { if ( sqlca.sqlcode < 0) dberror(sqlca.sqlcode, __LINE__); }
typedef char CHAR21[21];
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL TYPE CHAR21 IS STRING(21);
CHAR21 name="";
short ind=0;
EXEC SQL END DECLARE SECTION;
EXEC SQL
SELECT 'Tom Jones'
INTO :name :ind
FROM dual;
ORACHK;
I added the ORACHK because you absolutely need to check return codes in Oracle.
What you do is up to you. This one is not friendly it just exits. You realize this won't compile; it is several different things blobbed together.
I just had a filesystem / file corruption issue on my HSP's server due to disk capacity limits and fileswapping. I discovered that certain files got corrupted when fileswapping was not successful and they ended up with a string of control characters, or what I believe to be nulls, in them.
Does... (4 Replies)
Hi,
I am trying to replace nulls with spaces in every record of a '|' delimited file. I used this command -
cat input.dat | sed 's/||/| |/g' > output
But if a space appears twice '| | |' , then only the first null is getting replaced with a space. The second one remains as a null. I... (7 Replies)
When I try to sort a file where some records contain nulls i.e. hex 00 the sort truncates the record when it reaches the null and writes message:
"sort: warning: missing NEWLINE added at end of input file myfile"
I'm assuming from this that the sort sees the null as a special character and... (6 Replies)
Hello,
I am checking the length of each line of a fixed length file and making sure all lines are 161 length. My problem is that some files contain null characters which gets stripped out of my echo. How do I have the NULLs included in my check? (and I cannot replace or sub the NULL values with... (10 Replies)
Hi,
i have a file which contains data in fixed length. each row contains data of 10 characters fixed length. The data in the file appears like 4567782882
some times i may recieve dat less than fixed length of 10. in such a case i find nulls appended at the trailing spaces when i do a... (2 Replies)
I am trying to count the number of columns in a delimited flat file. The record is tab delimited. When I use the command wc -w, I am getting unexpected results when the record contains a NULL value. I believe it is because there is a "word" missing.
The below example will return 4 words... (2 Replies)
Ok,
I'm stuck here with a plan to get what I need done completed.
I want to use perl to produce a document. lets say the document will be a pdf document.
Now, is there a way for me to put a tiny little code in that pdf document that can make the pdf file null itself if run on a non-unix... (2 Replies)
Hi,
I've a PIPE delimited file with about 5 fields. Sometimes the records in the 4th field is null, so I want to replace it based on values we get it on 2nd field in the same file.
Following is an example.
ABCD|X-TYPE 3.0|2010|X-TYPE|20000
CDEF|C-TYPE 2.5|2011|C-TYPE|10000
XYZ|LX... (4 Replies)
I want to remove from a file the trailing null characters (0x00) and stop doing so when a different byte is found (which should not be deleted), and either put the result to the same file or a different one.
Any ideas? (9 Replies)
Discussion started by: Tribe
9 Replies
LEARN ABOUT SUSE
rollback_to_savepoint
ROLLBACK TO SAVEPOINT(7) SQL Commands ROLLBACK TO SAVEPOINT(7)NAME
ROLLBACK TO SAVEPOINT - roll back to a savepoint
SYNOPSIS
ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name
DESCRIPTION
Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again
later, if needed.
ROLLBACK TO SAVEPOINT implicitly destroys all savepoints that were established after the named savepoint.
PARAMETERS
savepoint_name
The savepoint to roll back to.
NOTES
Use RELEASE SAVEPOINT [release_savepoint(7)] to destroy a savepoint without discarding the effects of commands executed after it was estab-
lished.
Specifying a savepoint name that has not been established is an error.
Cursors have somewhat non-transactional behavior with respect to savepoints. Any cursor that is opened inside a savepoint will be closed
when the savepoint is rolled back. If a previously opened cursor is affected by a FETCH command inside a savepoint that is later rolled
back, the cursor position remains at the position that FETCH left it pointing to (that is, FETCH is not rolled back). Closing a cursor is
not undone by rolling back, either. A cursor whose execution causes a transaction to abort is put in a cannot-execute state, so while the
transaction can be restored using ROLLBACK TO SAVEPOINT, the cursor can no longer be used.
EXAMPLES
To undo the effects of the commands executed after my_savepoint was established:
ROLLBACK TO SAVEPOINT my_savepoint;
Cursor positions are not affected by savepoint rollback:
BEGIN;
DECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;
SAVEPOINT foo;
FETCH 1 FROM foo;
?column?
----------
1
ROLLBACK TO SAVEPOINT foo;
FETCH 1 FROM foo;
?column?
----------
2
COMMIT;
COMPATIBILITY
The SQL standard specifies that the key word SAVEPOINT is mandatory, but PostgreSQL and Oracle allow it to be omitted. SQL allows only
WORK, not TRANSACTION, as a noise word after ROLLBACK. Also, SQL has an optional clause AND [ NO ] CHAIN which is not currently supported
by PostgreSQL. Otherwise, this command conforms to the SQL standard.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], RELEASE SAVEPOINT [release_savepoint(7)], ROLLBACK [rollback(7)], SAVEPOINT [savepoint(7)]
SQL - Language Statements 2010-05-14 ROLLBACK TO SAVEPOINT(7)