DSXchange

If the database is expecting it in a different format then it would not have ran in with Datastage 8.7. Correct ? It runs fine in 8.7 but not in 11.5 is the issue. Just FYI...We already have a open PMR with IBM on this.

No. I don't get an error when I write to Sequential file. It works for date or string. It runs fine and I see a number. I have problems only when I write to database with that column. If I delete the column then even writing to database works fine. Only reason I am saying that is to denote that the ...

Arnd

Ray suggested the same and I tried it already using the following:

Iconv(DSJobStartDate,"D-YMD[4,2,2]")

Writing to sequential file and writing to DB without that particular column works just fine.

Ray

Thanks for the reply. I tried it and same results...

Thanks

We are upgrading from 8.7 to 11.5 and having issues with the server jobs. Few of the jobs uses transformer in which a column is defined as char(10) but it's a date but the target table datatype is DATE. This works just fine upto 8.7 but throwing error in 11.5. It does not give much of a message othe...

We have started using one of the Version control tools for Datastage jobs and when we add/check in the datastage jobs to VC using the Infosphere Information server Manager it creates a .pjb/.sjb files. We could take this .pjb file and do an import from Datastage designer but would want a way to do t...

Hashed file can overwrite record based on key mentioned in hashed file. Can I get same functionality in PX without using table. I mean using Dataset, fileset or lookup file set. I don't want to overwrite whole file. I want to achive kind of upsert functionality in file.

I have following setting in surrogate key generator stage.

Source Type= Flat File
Generate Key from last highest value=yes

I want to change highest value in Flat File from unix. This Flat File is in binary format. So How can I change Max value in this file from unix.

Hi,
Can you please explain in steps what you did. I am facing the same problem.

Thanx for your reply! Yes, there were some modules intialized into this project by the change control folks which is mostly why I want to revert it from a version repository. That way if they ever accidentally log on to this server again when first signing into VC at least the message "This pro...

When we migrated to DSEE 7.5.2 and I was setting up the projects I mistakenly made one of our deveopment projects a version repository. I want to revert it back and wondering if all I need to do is remove the APM tables from that project and will that break or negatively affect the project. besides ...

Hi,
Its my bad. Actually problem in file creation. When file is getting created with & sing in file name, it throws a warning. Please reply if someone had faced the same issue.

Suman, Was you able to resolve this problem. I am having the same issue. When I pass a parameter to oracle query with '&' sign in it, it throws the same warning. e.g. SELECT ID, NAME FROM PARTY WHERE PARTY_NAME = 'P&A' IF I pass any other value without '&' sign in PARTY_NAME then its wor...

I am having same problem. In my company, I can not demote that message to information because when we move the same job to test and prod environment, it will throw same error there. Same time when we call this job from sequencer, we are using "OK" and "Otherwise" option for succe...

Craig

I know I am reopening a old topic as I could not get any useful information on this topic. Do you remember what you did with this Issue ?

Thanks