DSXchange

rest of the msg:

db2command,0: Warning: db2command: [IBM][CLI Driver][DB2/NT] SQL0007N The character "€" following "dttm =" is not valid. SQLSTATE=42601

rest of the msg:

db2command,0: Warning: db2command: [IBM][CLI Driver][DB2/NT] SQL0007N The character "€" following "dttm =" is not valid. SQLSTATE=42601

Delete from tbl1 where dttm='2008-01-04 01:00:00'
above sql is passed as job parameter in 'BEFORE SQL'. Even if i just copy sql and run it gets the same error.

Im running db2.

How can i run db2 delete sql from a job ? I have tried to use DB2 stage with peek stage where i have used user defined sql as: SELECT TYPE FROM SYSCAT.TABLES fetch first 1 rows only; and in 'BEFORE SQL' im using: Delete from tbl1 where dttm='2008-01-04 01:00:00' as parameter. It gives me the followi...

File is already downloaded and exist in .txt format. Any specific columns format needs to be defined ?

Getting a flat file from mainframe in the following format (fixed length). an have the schema as follows. How to handle this data. Schema: --------- type char(20) code char(10) effdate date language char(1) office smallint mainoff smallint prov char(2) Data: ----- ADDR_PROV 99 0000000000000000E00107...

Ok we resolved the problem. We deleted the problem job and re-imported the job, after compiling it started running fine.

This problem started in another project in prod that was working fine. If it requires some patch to be fixed. Only these 3 errors im getting: main_program: Failed to open file: parameters RT_SC175\jpfile main_program: Parameter not resolvable: _ppWorkPath main_program: Parameterization Error: Parame...

Have a job in prod and it was running for months. Now it started giving this error:
Failed to open file: parameters RT_SC175\jpfile

Any idea ?

Thanks.

How to load cobol file schema although i have ftp'ed the shcema file from mainframe and it has all different levels of data i.e level 10, 05, 20 etc.
How can i output all level of data into a sequential file ?

I used DB2 Load utility to load from a seq. file that is around 10gb file. Utility gave some reject log and showing record number in it which are rejected or partially loaded. I want to see those rows from sequential file. I used a px job with transformer (running sequentially) and filter those reco...

Arnd,
So when i checked column 16 it had 2 rows with 1000-01-01 date. It means column counting starts from 0. That column was notnullable so db2 put that default date in it.

However i figured out the problem and fixed the rows. Thanks.

I checked columns 15, 16 and colum 15 and 16 is db2 date type width 10. Im running query for column 16 for any date that is not in the range.

its db2 date type.

I have a db2 table of around 400+ columns and it has around 9 million rows. Extracting from this table doing some transformation and loading to a .cob file. After loading few million rows it gave me the following error and then job was aborted because i have routine that aborts if warning comes up. ...