DSXchange

Hi, We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same? hi, You have first know the function(date,MTS function how it will work in Px when its migrated to px) so for intially you have to sample jobs in px toget the same output as server then you ca...

Hi, We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same? hi, You have first know the function(date,MTS function how it will work in Px when its migrated to px) so for intially you have to sample jobs in px toget the same output as server then you ca...

Hi, Can anyone help me to understand below elements in DB connection in datastage $DB2_CLIENT_INSTANCE_NAME $APT_DB2INSTANCE_HOME $DB2_SERVER $DB2_DATABASE How all are different from one another.While database connection in a job, how all these perform in which order? Thanks Hi Subrat, $DB2_CLIENT_...

Hi, Can anyone help me to understand below elements in DB connection in datastage $DB2_CLIENT_INSTANCE_NAME $APT_DB2INSTANCE_HOME $DB2_SERVER $DB2_DATABASE How all are different from one another.While database connection in a job, how all these perform in which order? Thanks Hi Subrat, $DB2_CLIENT_...

Your C compiler, is this case MicroSoft Visual C. ++, I assume. ... But there is a MSVC which is already installed. But i think,this MSVC which is installed in my PC is no way related to DataStage and i found that it is Microsoft .NEt framework which is being installed automatically when i installe...

Hi! I can't open some jobs in the Designer because the system claims that they are being accessed by another user. In the Director I can see that there are Record locks on those jobs (using Resorce Cleanup), but the processes which are reported to hold those locks do not exist in the system. Trying...

Hi,
Try this stage variable but data type should be varchar
Right(columnname,2) :'/' : Field(columnname,1) :'/' : Field(columnname,4)


Regards
Naveen.K

ray.wurlod wrote:Study the error message - get everything you can out of it. For example, what are these characters, and why can't they be converted? ...

Thanks Ray...
For your guidence
i will do that..once i get the result i will post the result...

Regards..Naveen.K

Hi Folks, i having problem in loading the data into the Oracle database and i am getting new error...if any body having any idea please share it main_program: Invalid character(s) ([xCD]) found converting string (code point(s): VALUE[x00][xCD][x09] [x00]) from codepage UTF-8 to Unicode, substituting...

The script can write straight to a sequential file by you cannot do that to a dataset. If you need to write into a dataset then you should do everything in a job DB2 -> DataSet. ... Can you provide any sample script which will help me a lot which writes that data directly to sequential file Regards...

The script can write straight to a sequential file by you cannot do that to a dataset. If you need to write into a dataset then you should do everything in a job DB2 -> DataSet. ... Can you provide any sample script which will help me a lot which writes that data directly to sequential file Regards...

Naveen, what have you tried so far? p.s. "ur" and "u" are not valid forms of "your" and "you"; this isn't an SMS site. ... i have retrieved the data from db2 with help of the script, and i dont how to write in the Sequential file or dataset.. p.s. you can sto...

Naveen, what have you tried so far? p.s. "ur" and "u" are not valid forms of "your" and "you"; this isn't an SMS site. ... i have retrieved the data from db2 with help of the script, and i dont how to write in the Sequential file or dataset.. p.s. you can sto...

Yes, it is possible. I am not going to ask you why you aren't doing this in a DataStage job as you have hopefully thought of that. You can execute a shell program and do your DB2 connect and query ... Hi Arndw, Thanks for ur reply, can u share any of the scripts or any tips to do that,so that it wi...

Hi Folks,

I have Requirement, i have to fetch two column records from the database(DB2) and write that into a dataset by using Shell Script or Routines.... is it possible..

Thanks in Advance

Regards
Naveen.K