DSXchange

mjohnson62982

The error I get now is:

The reported error is: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SFPTR_JACKPOT_FULL_LOAD;*N.N, DRIVER=3.66.46

mjohnson62982

It works if it is not in a parameter.

mjohnson62982

I'm sorry the partial load SQL is:

Code: Select all

DHYRTR = (select days (current date) - days (date('1900-01-01')) FROM SYSIBM.SYSDUMMY1)

mjohnson62982

I tried it without the double quotes and got the same message. But the reason I am using the parameter to give me the 2 options is that I need to allow the user to run the query to pull every row from the table or just the rows from the previous day.

mjohnson62982

Well it was a job transferring specified information from an iSeries table to a DB2 table. Not sure what it should have be labeled as. Sorry for any confusion.

mjohnson62982

I think it looks like this...

Code: Select all

DHYRTR <= (select days (current date) - days (date('1900-01-01'))+1 FROM SYSIBM.SYSDUMMY1)

I wonder is there a problem with putting characters like "<=" in a string parameter?

mjohnson62982

I attempted this fix, however I am still getting the same message.

mjohnson62982

I am currently trying to pass some SQL through a parameter that will allow the user to choose whether to do a full load of information from a table or to just load data from the previous day. The where clause of the select statement in the JDBC Connector looks like this: FROM "#Library_ps.Libra...

mjohnson62982

I don't know if it was actually Datastage that was crashing. My co-worker who manages the server said the server was crashing due to memory limits. He was the one that suggested I copy the data over one month at a time. I am pretty new with Datastage and was trying to see if there was a way I could ...

mjohnson62982

After the job gets to 5,200,000 rows the job freezes and will have to be shutdown in DS Director, or just sit there and eventually crash after a couple of hours.

mjohnson62982

I am currently having an issue copying the data from one DB2 table to another. The table is too large and causes the job to crash. What I would like to do now is copy data by a month at a time. Is there a way to set up a dynamic parameter that will allow me to have a the job to copy the information ...

mjohnson62982

Yes. Sorry. I wanted to know if the customer chose a specific location then the column for the customers emails would no longer be visible, or not included in the output at all.

mjohnson62982

I don't want the E-mail Address column to be seen for a specific location.

mjohnson62982

I have job that is gathering data on members of different locations within our corporation. For one location we do not need to have email field to show up. Is there a way to hide that field if the specific location is chosen from the list parameter before the job is run?

mjohnson62982

I am working on a job where the user would like to choose one or multiple selections from a list of locations and then have the parallel job run through the locations they choose. Is it possible to do this with a list parameter? If not is there a way to do this? The job is gathering information on m...

DSXchange

Search found 20 matches

Passing SQL through a string parameter

Data Copy Issue

Hiding specific columns

List Parameter Questions