DSXchange

bhasds

Hi BI-RMA,

I am sorry for the misinterpretation.I had concentrated on changing my existing code in the previous post.

bhasds

If you have doubt on-

Since A is the output from Unix cmd
will there be any different datatype for that?

Then you can apply the below on the execute command output

Trim(Convert(@FM,"",ExecuteCommand1.CommandOutput))

Or

Code: Select all

tr -d '\n'

Please let me know if it is not helpfull.

bhasds

Hi wittyme,

in transformer I wrote functions to get the value

If you are using transformer only to get the value of file1 then you can use the below in the filter option-

Code: Select all

grep "File1"|nawk -F"=" '{print $2}'

bhasds

Hi cutesanju As Craig said if you drop the headers then a little change in the previous code- In derivation, instead of this SV1:"|":SV2:"|":SV3 outputcol Use the below- Total_Data_Count:SV1:"|":File_Count:SV2:"|":Filter_Count:SV3 outputcol The other things wi...

bhasds

Hi qutesanju, You may try the below- 1.In stage variable of the transformer- SV1:",":col1 SV1 (initilize with null) SV2:",":col2 SV2(initilize with null) SV3:",":col3 SV3(initilize with null) 2. In derivation- SV1:"|":SV2:"|":SV3 outputcol Execute th...

bhasds

Hi brupun,

For decrypting the password field values-
Use echo #Parametername# in before or after job subroutine.
The value will be reflecting in the Director log.

bhasds

Hi cdp,

As a first step you may start with a script using Orchadmin commands.

1.Use orchadmin commands and dump the datasets into ascii files.
2.You can use loop either in unix script or in datastage job to accomplish your requirement.

bhasds

enjoy... :D

Please mark the topic as resolved.

bhasds

Hi wittyme,

You may also use a constraint in the transformer-

Code: Select all

Field(ToT.Col1,"=",1) ="file1"

or
a grep command in the filter option of the sequential file stage

Code: Select all

grep "file1"

bhasds

Hi praburaj, Although I do not have datastage in front of me as of now, you can try the below- In Stage Variable- juliandayfromdate(EndDate)-JulianDayfromdate(StartDate) SV1 In Loop condition- @iteration<=SV1+1 In Loopvariable if @iteration=1 then StartDate else DateFromJulianDay(JulianDayfromdate(S...

bhasds

we need to get the record into the output as if we are loading a whole record field by field

The above is possible using field function for each column derivation

Code: Select all

Eg-
  Field(SV1,"|",1)  col1
  Field(SV1,"|",2)    col2

bhasds

Hi Hemaarvind1,

You can comapare the entire record with two stage variable.
Eg- if you have col1 and col2 coming from the source

col1:"|":col2 SV1
If then else condition SV2
SV1 SV3

bhasds

Hi Stuartjvnorton,

Try the below-

In the output derivation for A in trnsformer-

Code: Select all

str(A:"|",B)

In the target sequential file Filter option-

Code: Select all

tr -s '|' '\n'

Please let me know if you are getting the desired output.

bhasds

Hi Cipsy, You can keep a User Variable activity in between the Sequnecer and the Notification activity. In Uservaribale activity- Jobname If Job_Activity1.$JobStatus =3 Then Job_Activity1.$JobName Else If Job_Activity2.$JobStatus =3 Then Job_Activity2.$JobName Else If Job_Activity3.$JobStatus=3 Then...

bhasds

Hi Jerome,

If I have understood the requirement, you need pass the schema name,table name and key col name as a parameter in the delete statement.

You can store these 3 parameters in a file and pass it from the job sequence as a parameter one by one.

Please let me know if this is helpful.

Search found 78 matches