DSXchange

Hi, Today i tested again with ODBC with follwing properties, Load options: 1) Insert only : The job got failed with below error "APT_CombinedOperatorController,0: Fatal Error: [IBM][CLI Driver] CLI0652W The execution of the query will not be atomic because the database server does not support a...

Hi,

I connected to DB2 using command editor and run the insert query manaully. The settings are fine in ODBC. ini file.

Hi, I have used taget stage as ODBC. Job design as below Dataset - Transformer - ODBC stage. Target DB is Mainframe DB2. Problem: Actaully target table is in Copy Pending state. Job runs fine without any error msg.But no rows inserted and updated in the table. My question is why ODBC does not throw ...

Hi Ray,

Please find below

PWD=/dwdsadm/home/Ascential/DataStage/DSEngine

Thanks,
Raj

ray.wurlod wrote:Is the PWD environment variable set? If not, set it to ".". ...

Hi Ray ,

I have type the cmd env in unix box, and i saw the pwd variable it set like as below

PWD=/users/n104799

Anything i need to do further..

Thanks,
raj

Hi All , I got below error in prod environment. buffer(30),4: Internal Error: (0):util/pathutils.C: 349: Unable to determine current working directory! This very likely due to a problem with file permissions on the directory or directories above this point. The error was Interrupted system call Trac...

Hi, I am using ODBC as target stage for loading data into Mainframe DB2 database.While running the job i got below error msg main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC DB2 Wire Protocol driver]Connection to application server DB2DSN would exceed the installation-defi...

Is this an interview question? Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind? Do you mean ODBC Enterprise stage or some other ODBC stag ... Hi Ray, I need to know how many rows get inserted or updated in a target table , I think ODBC stage providing ...

Hi All,

I am using ODBC stage as load,my target database is DB2.I need commit each 5000 rows.colud you tell me where i can set this option.

Thanks,
Raj

Hi, I am using modify stage for type conversion.My requirement is to convert string to timestamp. Modify Stage: MBROPRT_STS_DTS:timestamp[microseconds]=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss.6](MBROPRT_STS_DTS) Input is 2009-08-25 08:18:59.765482 , after conversion the output is 2009-08-25 ...

Hi All,

My requirement is need to export DSX files through unix command, i saw that there is command dsjob -import for import dsx files.

Please tellme how to export dsx file using unix command


Thanks,
Raj

Hi, I have tried in all ways include quote like 'DomainName\userid' and DomainName\\userid.But I got same output without any improvement. Thanks! Add one more backslash before the existing backslash or else put a single quote at the beginning and end of UserId like UserId:'DomainName\userid'.. Hi , ...

Hi , My requirement is to transfer file from one server to another server. Script is: ftp -v -n -i $pHost <<EOD user $pUserId $pPassword $pFTPFormat put $pSrcFilePath $pTgtFilePath EOD Example : Paramters: pHost : xxxxx.com UserId:DomainName\userid pPassword:********** pFTPFormat:ascii pSrcFilePath:...

basu.ds wrote:try using uri as your server ip

File is present in my server1, i need to ftp this file to server2.
so i used uri=ftp://server2.

Hi, My requirement is ftp file from one server to another server. Example: Server 1: File1 I need to FTP file1 to server2. In the FTP stage i mentioned below things URI=ftp://hostname/ ftp Command = put path/srcfilename targetfilename Password = ******* username= abc I got below Error: FTP_Enterpris...