DSXchange

Hello: Need to load data on DB2: - During the very First load, store the last record number. - During the next load need to check for the last record number and then start loading data after that record number. There is a Primary key column called REC_NUM where it sequentially stores the rec number....

Actually, I wasn't thinking of creating a new column is DB2, just passing an extra data item (that does not exist in the table) to the plugin.

Cool. Yes, that is a great idea. Thanks.

Was the spare column you used already in the table? Or did you just pass an extra column with the same value to the DB2 plugin? Yes, the spare column I used is already in the table. If the column already existed, then it is no longer being maintined by your job and will quickly get out of date. Tru...

Hello rleishman: Thanks for your prompt reply. What I think you've done is supplied more question-marks than there are columns I had used the SQL generated query and then copied it and pasted that query in the user defined query and then modifed to compare. However, there was definitely something wr...

Hello: Background: - Trying to do update / insert into DB2 directly using DB2 Plugin. - Need to update based on a column called LAST_MOD_DTS. If on DB2 the date of LAST_MOD_DTS is LESS then the input column's LAST_MOD_DTS then go ahead and update. - The input file's LAST_MOD_DTS column is a Char 26 ...

Furthermore about this job. I am doing a direct insert Update into the DB2 table. - My Update Actions is set to Update existing or insert new rows since most of the row will be updates. - Set Array Size to 1 due to insert/update and -Transaction size to 0 since we want to commit the rows after all r...

Hello: In the Server Job I am loading data directly into the DB2 Table using the DB2 Plugin. However I am getting the following error: Job name:[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22 The job flow is as follows: HashFile | \/ Input file ---> Link Partitioner --->Shared container-...

Thank you very much and appreciate your quick responses. Looking forward to the new release of DataStage Hawk. As usual this site is great for information.

Hello: Need advice on CVS and whether it can be used with DataStage Server 7.5. Brief info on CVS: CVS (Concurrent Versions System) is used for two purposes: record keeping and collaboration. That one can perform Open Source Development With CVS. Need to know whether its compatible with DS Server? L...

You need IConv I was talking that if after doing ICON conversion in transform using field type as date and if one wants to load to db2 using the DB2 UDB plugin directly and if the load fails then what worked for me was to set the type column on the db2 udb to char even though in the transform I hav...

Try using "LST_PYMT_DT" column as CHAR and it should work.

DS_MJ

ray.wurlod wrote:I believe the Right() function is more intuitively obvious.

Code: Select all

Right(InLink.Col1, 1)

Hello:

Thank you. works.

Thanks,
MJ

Hello All: My source file is a Complex flat file with Data Format set to EBCDIC and Record Style to Binary. I can view data fine. In the table there is a column set to columnname char 1. The source file for that column is sending us something like 198655T. We need to accept only the character which ...

It simply means to have the packed fields unpacked. Not an 'internal' representation, but rather something 'external' or people readable. Hello chulett: Thank you much, appreciate it. :D Anyways, we tried to get the DATA in ASCII and had issues with Packed decimal. However, when we went with DataSt...

You may need to post the definition of the file you are receiving to make sure we are all on the same page. If your file truly has packed decimal fields and if they simply converted the entire record from EBCDIC to ASCII - then they have destroyed the packed fields in the process. Packed is packed,...