DSXchange

As i've found Netezza Connector giving problem. I've replaced with ODBC Connector and its work Comparing two database output result DB2_Connector ----->CheckSum--->SequFile [Already Working] Netezza_Connector---->CheckSum--->SeqFile [ Not Working ] ODBC_Connector----->CheckSum--->SeqFile [Working ] ...

Dear All, I'm testing the result of number of tables output by using CheckSum(ComputationMode=Use All columns) , and the source DB2 Connector setup as RCP (Runtime Column Propagation) and its work fine. Db2Connector --> CheckSum-- SequentialFile The above is working fine, the problem is in follow us...

Hi All I may be doing silly mistake, All I need simply to check the condition if toda'ys date = Monday or 2 then its move to next control and run the Job otherwise it pass value "No" I've used the following condition under expression. Name = Yes Expression Type = Customer-(Conditional) Exp...

Select the first line as Header and then

Under "Format" tab
I've done the settings as follows:
Final delimiter = end
Recod Delimiter = newline
Field defaults:
Delimeter = comma
Quote = Double

Thanks Ray ..
You have spotted the problem. I've found one the Transformer Control in the stream kept the CHAR instead of VARCHAR that's why its was showing \esacpe character \0.

When I change to VARCHAR its fixes the problem.
Many thanks for your support

Have a good weekend
F

Dear All I'm generating the CSV file the column have got Postcode field as a last colum/field.Where the file have No Postcode or have three char of the 1st and 2nd Part of the Postcode like "GU1" 4LM it generate the NUL or escape_char i.e. \0 or NUL at the end of the row as shown below: th...

Dear All, I've a simple SEQUENCE job 'x' which runs successfully when I run manually but when I schedule the 'x' SEQUENCE job the Status keep showing 'Running' but doesn't do anything the Log show like: SHFT_Sequence: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH One of th...

Spoke to IBM they won't recommend to use connection on MS Access.
So I've to export/download the table output into CSV and then use the csv files to work through in my ETL Datastage Job.

I will post once I will any success.
Kind regards,
Farhan

Hi Eric, Sorry for late reply Thanks Eric for your response. I've tried on Server job by creating a row keep CR/LF middle of the column/field and I think it was working However, I've requested to Data provider to correct from their end, so I don't need to handle it at my side. I'm sure there must be...

so looking the data can build the logic as last column values can pass on "Record_Delimeter_String" = \" \r \ n Record Delimiter String = \" \r \n Final Delimiter = end Does not work When I use folllowing condition Record Delimiter String = \r \n Final Delimiter = end It view onl...

Hi All , Some of the rows from my Sequential file (csv) are rejecting. The reason CR/LF within the field. Do you think I can handle this problem by setting up the right properties/format parameter on Format|Record_level. If it LineFeed (LF) I could handle them by using Properies|format (Record delim...

Thanks Vinsashi
your code was quite helpful for me to handle Invalid Julian Date
Kind regards
Farhan

How Stupid it is

I've add one more Transformer into the Stream specifically to calculate this (Minutes) Length-of-Admission and its work.

As before there were other calculation already happend it may confilicting with the other variables.... don't know why....

Regards
Farhan

Hi All Would be grateful if you could help me The the following functions calculate total 'Minutes' between (Admission and Discharges.) svAdmissionDate = '2013-01-01' svAdmissionTime = '23:55:00' svDischargeDate = '2013-01-02' svDischargeTime = '09:00:00' svDaysBetween = DaysSinceFromDate(svDischarg...

Thanks a lot Priyadarshikuna
Its work perfectly fine.

Kind regards
Farhan