DSXchange

anbu wrote:

Code: Select all

DaysSinceFromDate(Date1,Date2)

I tried but this is not working. I am just getting 0 days. I am not getting exact days. I am trying to load the difference into integer datatype. Does this makes any diff.?

hi
I tried, I did not get expected result
here is what I tried
DaysSinceFromDate(Date1) - DaysSinceFromDate(Date2)

Hi I am trying to get no. of days from two dates. Source dates Date1 Date2 10/23/2010 10/25/2010 10/20/2010 10/22/2010 10/19/2010 10/22/2010 Read as varchars and converted to date format using stringtodate func. Now Date1 and Date2 are date datatypes Date1 Date2 2010-10-23 2010-10-25 2010-10-20 2010...

ray.wurlod wrote:See if a server Sequential File stage - either in a server job or in a server shared container - can read this file properly. You can use a server shared container in a parallel job. ...

Excellent ray, it worked. Really appreciate that.
Thanks

I just noticed problem in your data. Correct your data 100,200,300,A,"34,00","64,000","0,23" 200,200,500,B,"22,000","11,0" ," 12,00" Sorry, thats my typing error, data in file is correct with double quotes and having a comma in it Thanks

Please read my posting clearly before suggestion I am saying comma within quotes is getting treated as delimiter which should not..THATS MY ONLY CONCERN PLEASE DONT SUGGEST, LENGHT PROBLEM OR SOME TRUNCATION PROBLEM. Hi I want to read .csv file data using seq. file stage, but I have an issue here Da...

Your quote setting should work. Truncation problem is due to your length defined for that field. Increase your length, then you should be able to read the data. Hi thanks for ur reply. its not the problem with length, its varchar with no length specification. You can check from ur end placing the s...

If you define Quote as double, then you are fine. Were you able to run your successfully? Hi Quote=double also I have done it before which I already mentioned in my first post. Its not going to work, because within quotes , comma is there, which is getting treated as delimiter and my values is gett...

Hi I want to read .csv file data using seq. file stage, but I have an issue here Data is as follows (presume all are varchar datatypes) 100,200,300,A,"34,00","64,000","0,23" 200,200,500,B,"22,000","11,0"12,00" Here is the issue, because the valu...

Hi I have a requirment like this Input data abcd@yahoo.co.in cde@yahoo.co.in xyz/yahoo.co.in pqrs yahoo.co.in ******* lmn@yahoo.co.in mgns@yahoo.co.in So, i have to capture the ids before @ in one file and also if @ is not there, there will be some / or some space after ids I have to capture those i...

Hi,
Could anyone help me how to delete datasets using Orchadmin command in DataStage. Need little more specific in which stage I can do this

Thanks in advance

ray.wurlod wrote:What do you put in the cases job parameter? Do you escape the quote characters?

Search DSXchange for examples of where DataStage drops quotes from job parameter values, particularly in SQL. ...

input as A300,B400 (in datastage during runtime)

also tried this way

A300','B400 still did not work

Hi I have question regarding input of parameter values during run time Here is the example Suppose I have a query like this in db2 stage select * from TABLE1 where caseid in ('#cases#') I have to input some cases (eg. like A300,B400 etc) during runtime How can i do that I have input like this during...

austin_316 wrote:It will be stored in the path something like/projects/IBM/InformationServer/Server/Projects/<Project>. please check there.

Thankyou soo much Austin

Hi

I did not give any file path in seq. file stage but just gave file name. Where does that file save by default. I checked root directory and home directory but I did not find it.

Please help me with this, thanks in advance

Kris