DSXchange

I did try the double quotes. It doesn't work.

I have a query. SELECT col1 FROM table where Col2 in('A','B'). I declared a parameter in DSjob as indicator. #indicator#. SELECT col1 FROM table where Col2 in(#indicator#) I want to pass 2values for this #indicator#. The DD log shows that job fails because of the bad query SELECT col1 FROM table whe...

I have an input as
col1 col2 col3 col4 col5
57 58 59 60 61.

I want the output as
col1 = 57
col2 = 58
col3 = 59
col4 = 60
col5 =61

Can I use a pivot stage for this?.If so how can I use.I dont have the plug-in documentation installed for this.

Please help.

I have to calculate the sum of rows in a particular column. The input column datatype is decimal.I have given the output column length as decimal(15,2).When I look at the output zeros are padded.Ex: if the sum is 879897.79 .The output is 000000000879897.79 1.how I can get of rid of zeros before the ...

I tried the logic which was suggested. I was able to do it.

Thanks for the help.

xx

Thanks

I have to calculate the sum of all the rows in a particular column .If I use the Aggregate Stage I have to provide the grouping key but there is no Grouping key.it is simply calculating the sum of all rows in a column of a source file. Can I use the aggregator stage for this ?

Please help.

What i have is read n write permissions on the file that means i should be able to read the file how ever its not allowing to read. Iam not able to do chmod on the file.

Iam rejecting the data from look up stage if look up fails. Iam redirecting rejected data to a sequential. I could view the data from the sequential file stage view tab but when i try to view data on the unix box it shows me a file which got created but when i try to view it in the editor it doesnt ...

I have a source feild whose datatype is varchar. I have to convert this to SmallInt in Target. What kind of a function I can use in Transformer.
Please suggest.


Thanks

TeraGenericQuery Error: DB Call Failure(success check) Info = 2631, Code = 3132, Message = Access Logging step has failed. The transaction was aborted. Session return code = 3,132 , DBC return code = 0 TeraSync: control state query failed: "lock row access select col1, col2, col3, col4 from Dat...

I did that in before job subroutine but I have space issues. When I unzip the files I get the error " No disk space". I am reading all the files in the sequnetial files and using the filter=gunzip . If I use this will I have any space issues?.

I have bunch of Zip files. All the file names start with same name ex:
file1
file2
file3
.
.
.
.
.
filen
I am using FilePattern. But all my files are Zip files.How can I read these Zip files as Filepattern does not have the filter option.
Please help.

My source length is bigger than Target.I have 241 columns. The datalength for all the columns is greater than target length.