DSXchange

I searched in archive and the following code executes db2 sql perferctly. Still i am wondering why my previous code does not work! Any help or suggestion on this will be greatly appreciated Thanks in advance $INCLUDE UNIVERSE.INCLUDE ODBC.H ** Initialise parameters ODBC henv = SQL.NULL.HENV hConn = ...

Thanks Ray for your input! I have tried testing a job, but I got following error message COUNT_RECORD_IN_HASHFILE..Sequential_File_2.IDENT1: |COUNT_RECORD_IN_HASHFILE..UniVerse_1.DSLink4: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:SELECT COUNT(*) FROM HASHRECORD SQLSTATE=S0002, DBMS.CO...

Hi,
My requirement to fire sql query in a hash file and get record count based on where condition.

For example,
Select count(*) from hash_file where record_status='Active'

where record_status is column name

If you have any idea/suggestion, kindly let me know.

thanks in advance

What is the source datatype? and what is the target db2 date format?

Depending upon your target format, use iconv and oconv function accordingly like

Thanks Craig! I added your suggestion, this time job runs fine, but SystemReturnCode deos not return 0 and record is not inserting. Moreover ResultText doesnot retun any information. DB2Cmd1="db2cmd;db2 connect to sample user test using test; db2 insert into db2admin.add(name,phone) values('ABC...

Presently I am capturing filtered and rejected rows into db2 table using following constraints at transfomer stage. LNK_Write_Account_Mst_Filtered---> LNK_Write_Account_Mst.REJECTEDCODE = DSE.NOERROR And LNK_Write_Account_Mst.REJECTED LNK_Write_Rejects---> LNK_Write_Account_Mst.REJECTEDCODE where LN...

I have modified the code and tried to run, but the job aborted sayting Job stopped - before-job routine returned error: Error variable unassigned on return from BEFORE routine DSU.tempSql DB2Cmd1="db2cmd;db2 connect to sample user test using test; db2 insert into db2admin.add(name,phone) values...

chulett wrote:Umm... you need to run it from 'DOS' rather than 'TCL'. ...

Thanks Craig for input,
even I tried using DOS, I didn't get compilation error, but it returns 1

Don't you need a quit in DB2Cmd ?

Ray: Do you mean connect reset command?

Please advice where I am going wrong.

UV or Hashed File stage querying DS_JOBS excluding any where name begins with a "/" or "" character, returning columns NAME and CATEGORY (both VARCHAR). ... Thanks Ray! Do I need to create a job for same? Can you please explain me little bit more details with syntax. Thanks in a...

I have created one simple sever routine as below, where I am connecting to database and trying to insert one record into a table. There is no compilation error and while testing it returns 0, but record is not inserting into table. Could you please let me know where I am going wrong? and what is sol...

Hi rafik2k , Could you let me know how did go about creating the test job of urs which displayed all the jobnames of the current project Thanks in advance Create simple job with Transformer stage and linkt to it a sequential file stage for capturing out in text or csv format. In transformer do the ...

Thanks RelianceDss and Craig.
Ya I now see service pack 2 on my machine.
I need to ask patch from ibm support team.

Download blah.exe from the Web; it's a good SMTP client. If i were you , id have marked it as premium-premium content. Available only on payment of a small fee. :wink: And Sorry for the plagiarism(almost) which i myself condemn. First thing is that you are Rameshrr3, not Ray! blah.exe is 100% free ...

ray.wurlod wrote:Download blat.exe from the Web; it's a good SMTP client. ...

Thanks a lot Ray!
I searched in google for blat.exe and found following site Blat - A Win32 Command Line SMTP Mailer

Is that same site for downloading blat.exe?

Can you check using simple trim and upcase funtion only

If(UpCase(trim(<Source.column_name>))=UpCase(trim(<Lookup.column_name>))
then 'Y' else 'N'

BTW what is metadata for above mentioned table?