Trying to insert a mix of non-static variables and retrieved values into a table2019 Community Moderator ElectionInsert into … values ( SELECT … FROM … )Add a column with a default value to an existing table in SQL ServerSQLite - UPSERT *not* INSERT or REPLACEInsert results of a stored procedure into a temporary tableFinding duplicate values in a SQL tableWhat are the options for storing hierarchical data in a relational database?Insert into a MySQL table or update if existsupdating table rows in postgres using subqueryDB2 Error. Inserting to a table through select queryDb2 sqlcode -20186
If the DM rolls initiative once for a group of monsters, how do end-of-turn effects work?
My Graph Theory Students
What should tie a collection of short-stories together?
How to terminate ping <dest> &
How can I track script which gives me "command not found" right after the login?
Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?
Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?
A sequence that has integer values for prime indexes only:
Professor being mistaken for a grad student
Why do Australian milk farmers need to protest supermarkets' milk price?
Why would a flight no longer considered airworthy be redirected like this?
Do I need life insurance if I can cover my own funeral costs?
How to explain that I do not want to visit a country due to personal safety concern?
How to create the Curved texte?
Gantt Chart like rectangles with log scale
Does someone need to be connected to my network to sniff HTTP requests?
Are ETF trackers fundamentally better than individual stocks?
How to make healing in an exploration game interesting
Could the Saturn V actually have launched astronauts around Venus?
how to write formula in word in latex
Gravity magic - How does it work?
What's the meaning of “spike” in the context of “adrenaline spike”?
Continuity of Linear Operator Between Hilbert Spaces
PTIJ: Who should I vote for? (21st Knesset Edition)
Trying to insert a mix of non-static variables and retrieved values into a table
2019 Community Moderator ElectionInsert into … values ( SELECT … FROM … )Add a column with a default value to an existing table in SQL ServerSQLite - UPSERT *not* INSERT or REPLACEInsert results of a stored procedure into a temporary tableFinding duplicate values in a SQL tableWhat are the options for storing hierarchical data in a relational database?Insert into a MySQL table or update if existsupdating table rows in postgres using subqueryDB2 Error. Inserting to a table through select queryDb2 sqlcode -20186
So I'm trying to insert a collection of non-static variables and values fetched from another table into a table using a subquery. My code looks like this:
INSERT INTO SCHEMA.TAB_REQ(TABLE_I, RUN_I, CODE, ORG_ALS, TAB_CRT_S, TAB_LST_UPD_S)
SELECT :tableKey, :runKey, :code, :org, TAB.CRT_S, TAB.LST_UPD_S
FROM SCHEMA.TABLE TAB
WHERE TAB.KEY = :tableKey
The values being fetched, TAB.CRT_S and TAB.LST_UPD_S, are both going to be timestamps. So "12/3/2019 12:00:01 AM" as an example. Neither of these values should ever be null. They're automatically generated whenever a new row is inserted.
The provided variables are going to be two strings of integers (:tableKey and :runKey) and then two strings (:code and :org). They're provided by a java application, and if they're missing then something has gone terribly wrong. Right now I'm manually entering values for each variable when I run the query.
The select statement should only return a single row, because :tableKey is an automatically generated unique identifier.
My current code is throwing the following error:
ERROR [42610] [IBM][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value.
Is this possible, or do I need two seperate queries here?
sql db2
asked Mar 6 at 19:58
Some_GuySome_Guy
66
add a comment |
So I'm trying to insert a collection of non-static variables and values fetched from another table into a table using a subquery. My code looks like this:
INSERT INTO SCHEMA.TAB_REQ(TABLE_I, RUN_I, CODE, ORG_ALS, TAB_CRT_S, TAB_LST_UPD_S)
SELECT :tableKey, :runKey, :code, :org, TAB.CRT_S, TAB.LST_UPD_S
FROM SCHEMA.TABLE TAB
WHERE TAB.KEY = :tableKey
The values being fetched, TAB.CRT_S and TAB.LST_UPD_S, are both going to be timestamps. So "12/3/2019 12:00:01 AM" as an example. Neither of these values should ever be null. They're automatically generated whenever a new row is inserted.
The provided variables are going to be two strings of integers (:tableKey and :runKey) and then two strings (:code and :org). They're provided by a java application, and if they're missing then something has gone terribly wrong. Right now I'm manually entering values for each variable when I run the query.
The select statement should only return a single row, because :tableKey is an automatically generated unique identifier.
My current code is throwing the following error:
ERROR [42610] [IBM][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value.
Is this possible, or do I need two seperate queries here?
sql db2
asked Mar 6 at 19:58
Some_GuySome_Guy
66
3
What is your question? Does this code work? If not, what is the problem?
– Gordon Linoff
Mar 6 at 20:00
Edited for clarity.
– Some_Guy
Mar 6 at 20:19
An example of the data being grabbed here and inserted would be useful. Are there any null values in the fields being "selected"?
– Karlomanio
Mar 6 at 20:48
Are the added details the sort of example you were looking for?
– Some_Guy
Mar 6 at 21:13
Show the part of your java code, where you work with the corresponding PreparedStatement / DB2PreparedStatement variable.
– Mark Barinstein
Mar 7 at 4:59
add a comment |
So I'm trying to insert a collection of non-static variables and values fetched from another table into a table using a subquery. My code looks like this:
INSERT INTO SCHEMA.TAB_REQ(TABLE_I, RUN_I, CODE, ORG_ALS, TAB_CRT_S, TAB_LST_UPD_S)
SELECT :tableKey, :runKey, :code, :org, TAB.CRT_S, TAB.LST_UPD_S
FROM SCHEMA.TABLE TAB
WHERE TAB.KEY = :tableKey
The values being fetched, TAB.CRT_S and TAB.LST_UPD_S, are both going to be timestamps. So "12/3/2019 12:00:01 AM" as an example. Neither of these values should ever be null. They're automatically generated whenever a new row is inserted.
The provided variables are going to be two strings of integers (:tableKey and :runKey) and then two strings (:code and :org). They're provided by a java application, and if they're missing then something has gone terribly wrong. Right now I'm manually entering values for each variable when I run the query.
The select statement should only return a single row, because :tableKey is an automatically generated unique identifier.
My current code is throwing the following error:
ERROR [42610] [IBM][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value.
Is this possible, or do I need two seperate queries here?
sql db2
asked Mar 6 at 19:58
Some_GuySome_Guy
66
So I'm trying to insert a collection of non-static variables and values fetched from another table into a table using a subquery. My code looks like this:
INSERT INTO SCHEMA.TAB_REQ(TABLE_I, RUN_I, CODE, ORG_ALS, TAB_CRT_S, TAB_LST_UPD_S)
SELECT :tableKey, :runKey, :code, :org, TAB.CRT_S, TAB.LST_UPD_S
FROM SCHEMA.TABLE TAB
WHERE TAB.KEY = :tableKey
The values being fetched, TAB.CRT_S and TAB.LST_UPD_S, are both going to be timestamps. So "12/3/2019 12:00:01 AM" as an example. Neither of these values should ever be null. They're automatically generated whenever a new row is inserted.
The provided variables are going to be two strings of integers (:tableKey and :runKey) and then two strings (:code and :org). They're provided by a java application, and if they're missing then something has gone terribly wrong. Right now I'm manually entering values for each variable when I run the query.
The select statement should only return a single row, because :tableKey is an automatically generated unique identifier.
My current code is throwing the following error:
ERROR [42610] [IBM][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value.
Is this possible, or do I need two seperate queries here?
sql db2
sql db2
asked Mar 6 at 19:58
Some_GuySome_Guy
66
asked Mar 6 at 19:58
Some_GuySome_Guy
66
edited Mar 6 at 21:04
Some_Guy
asked Mar 6 at 19:58
Some_GuySome_Guy
66
asked Mar 6 at 19:58
Some_GuySome_Guy
66
asked Mar 6 at 19:58
Some_GuySome_Guy
66
66
3
What is your question? Does this code work? If not, what is the problem?
– Gordon Linoff
Mar 6 at 20:00
Edited for clarity.
– Some_Guy
Mar 6 at 20:19
An example of the data being grabbed here and inserted would be useful. Are there any null values in the fields being "selected"?
– Karlomanio
Mar 6 at 20:48
Are the added details the sort of example you were looking for?
– Some_Guy
Mar 6 at 21:13
Show the part of your java code, where you work with the corresponding PreparedStatement / DB2PreparedStatement variable.
– Mark Barinstein
Mar 7 at 4:59
add a comment |
3
What is your question? Does this code work? If not, what is the problem?
– Gordon Linoff
Mar 6 at 20:00
Edited for clarity.
– Some_Guy
Mar 6 at 20:19
An example of the data being grabbed here and inserted would be useful. Are there any null values in the fields being "selected"?
– Karlomanio
Mar 6 at 20:48
Are the added details the sort of example you were looking for?
– Some_Guy
Mar 6 at 21:13
Show the part of your java code, where you work with the corresponding PreparedStatement / DB2PreparedStatement variable.
– Mark Barinstein
Mar 7 at 4:59
3
3
What is your question? Does this code work? If not, what is the problem?
– Gordon Linoff
Mar 6 at 20:00
What is your question? Does this code work? If not, what is the problem?
– Gordon Linoff
Mar 6 at 20:00
Edited for clarity.
– Some_Guy
Mar 6 at 20:19
Edited for clarity.
– Some_Guy
Mar 6 at 20:19
An example of the data being grabbed here and inserted would be useful. Are there any null values in the fields being "selected"?
– Karlomanio
Mar 6 at 20:48
An example of the data being grabbed here and inserted would be useful. Are there any null values in the fields being "selected"?
– Karlomanio
Mar 6 at 20:48
Are the added details the sort of example you were looking for?
– Some_Guy
Mar 6 at 21:13
Are the added details the sort of example you were looking for?
– Some_Guy
Mar 6 at 21:13
Show the part of your java code, where you work with the corresponding PreparedStatement / DB2PreparedStatement variable.
– Mark Barinstein
Mar 7 at 4:59
Show the part of your java code, where you work with the corresponding PreparedStatement / DB2PreparedStatement variable.
– Mark Barinstein
Mar 7 at 4:59
add a comment |
1 Answer
1
active
oldest
votes
I figured out a much simpler way to do what I needed. Instead of trying to gather all the data that I needed in a single query, I wrote two simple select statements and used them to insert the extra parameters into my java variable before it populated the variables in this SQL statement.
answered Mar 7 at 15:58
Some_GuySome_Guy
66
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55031270%2ftrying-to-insert-a-mix-of-non-static-variables-and-retrieved-values-into-a-table%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I figured out a much simpler way to do what I needed. Instead of trying to gather all the data that I needed in a single query, I wrote two simple select statements and used them to insert the extra parameters into my java variable before it populated the variables in this SQL statement.
answered Mar 7 at 15:58
Some_GuySome_Guy
66
add a comment |
I figured out a much simpler way to do what I needed. Instead of trying to gather all the data that I needed in a single query, I wrote two simple select statements and used them to insert the extra parameters into my java variable before it populated the variables in this SQL statement.
answered Mar 7 at 15:58
Some_GuySome_Guy
66
add a comment |
I figured out a much simpler way to do what I needed. Instead of trying to gather all the data that I needed in a single query, I wrote two simple select statements and used them to insert the extra parameters into my java variable before it populated the variables in this SQL statement.
answered Mar 7 at 15:58
Some_GuySome_Guy
66
I figured out a much simpler way to do what I needed. Instead of trying to gather all the data that I needed in a single query, I wrote two simple select statements and used them to insert the extra parameters into my java variable before it populated the variables in this SQL statement.
answered Mar 7 at 15:58
Some_GuySome_Guy
66
answered Mar 7 at 15:58
Some_GuySome_Guy
66
answered Mar 7 at 15:58
Some_GuySome_Guy
66
answered Mar 7 at 15:58
Some_GuySome_Guy
66
66
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55031270%2ftrying-to-insert-a-mix-of-non-static-variables-and-retrieved-values-into-a-table%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
What is your question? Does this code work? If not, what is the problem?
– Gordon Linoff
Mar 6 at 20:00
Edited for clarity.
– Some_Guy
Mar 6 at 20:19
An example of the data being grabbed here and inserted would be useful. Are there any null values in the fields being "selected"?
– Karlomanio
Mar 6 at 20:48
Are the added details the sort of example you were looking for?
– Some_Guy
Mar 6 at 21:13
Show the part of your java code, where you work with the corresponding PreparedStatement / DB2PreparedStatement variable.
– Mark Barinstein
Mar 7 at 4:59