DSXchange

Hi

I am using DB2UDBload stage to load bulk data.I am not able to specify dumpfile path in client.If i specify dumpfile path as server path it works fine.Incase of client it throws an error,Path is invalid.But my requirement is to specify client path for dumpfile
pleas help.

Thanks

Hi

I have the following set of records:

Empno name
1 Ash
1 Ush
2 Reeta
3 x
4 Y

I have retain first record and capture rejected records...I cant use remove duplicates since it does not have reject link.

Please help

Hi,

I need a function/system variable similar to @Date in Server.It should do the following:
At the first call in a job, the function calls the operating system for the date. On the second and subsequent calls, the function returns the value of the first call.

Thanks.

Hi
I have datetime column which can be either in this format :
'21-01-2008 12:00:00' or '21-01-2008'.

I have to convert timestamp to date:
TimestampToDate function accepts only timestamp as input.

Please let me know as how to convert the same.

Thanks

Hi

Please give me idea to develop parallel routines to trace log from director .I have developed routine in server.
Is there any better way to trace in EE.
Thanks

I am using v7.5.1.I think its not properly installed.

Hi Please let me know the partition method to use in the following: Requirement:Partition by key: Description:Distributes data records to its output flow partitions according to key values. I am using hash.Please let me know if its correct Partition by Expression: distributes data records to its out...

Thanks so much for your reply.I used

Seq file->pivot->seq file

Also tried usingDataset,ODBC.

When I connect Pivot to any of the output stages, I get the error.

Hi

I tried to use PivotPX .My job looks as below

File->Pivot->output File

but when I connect pivot to output it gives an error

(40822):The source stage cannot have output link

Thanks

Hi, I have a file with following data: Col1 col2 132Asha,12 133Nimi,13 in the above 132 is empno of width 3.Rest are Empname. in the destination file it should go as col1 col2 col3 132 Asha 12 133 Nimi 13 Please let me know if we have options to get the above requirement. In other tools we have opti...

Hi I have a requirement as below: I give input to my as seconds datetimefromunixtime ( integer(8) seconds ) -It should return a datetime from a count of seconds since 1970 (UNIX time). My code: temp=0 flag=0 if ((TimeInSec>=-4 AND TimeInSec<0) ) then Ans = " 01 JAN 1970 12:00:00am" end if ...

Hi

Is it possible to use remove duplicates stage to extract unique records.I am requirement analysis phase.I do not have DS parallel.

ex:
Emp id
1
1
2
3
3

only 2 should go.In the manual i could find only first and last options

Thanks

Sorry if I was not clear

I have 2 cols Subject Empid
Subject has the data :Arun,Hi
Empid:1233

File is as below:
Arun,Hi,1233

When I load Arun gets into subject hi gets into Empid...

Thanks

I have comma delimited file.The data for col1 has comma in between i.e ab,cd
Data for col2 is dfg.

since its comma delimited,cd is assigned to col2 instead of dfg.My requirement is ab,cd should go to col1.

Thanks

Hi

I have a comma delimited file.I have data as below

ab,cd,-Col1

dfg-col2

Since its comma delimted cd is assigned to col2.Please let me know how to avoid
Thanks