DSXchange

[quote="keshav0307"]try this query SELECT * FROM DS_JOBS WHERE NAME='<exact job name>' what does it return?[/quote] I am trying to re-import the error from datastage designer (v.8.0.1) then gives me a mesg "No objects found for import!" but I can see the job already exisitng in t...

Hi All, when i try to re-import a job into designer it is giving me a message; " No objects found for import!". the job does not exist in the designer repository However I can see the job already existing in the director. when i try to delete the job from the director it is giving me a mes...

Hi All,

When ever I log in into datastage it is quickly giving me a message "connection broken" or "connection refused" or rpe daemon is not running" etc.

can anyone please suggest me what should I do to eliminate such messages.

Thanks
Mark

Hi All,

How do I verify my DB2 queries where the data is loaded into mianframe.

I was able to logon to mainframe using MVFS connectivity and it does not look good at all.

Please give me suggestions.

Thanks & Regards
Mark

Thanks a bunch guys for all the suggestions.

I ran the job and able to see the desired output.

Regards
Mark.

[quote="kumar_s"]As i already specified in my previous post, you need to use Aggregator stage to group by the Key and find the Max for the rest of the fields. ...[/quote]

Thanks I will do that.

Regards
Mark

[quote="kumar_s"]So extend a third link which is is for other cases (Not 1043 1059) and perform the same funnel and group by. ...[/quote] So i will have 3 output links coming out of my transformer and then I will use a funnel stage to combine all those 3 links to single output (I want only...

[quote="kumar_s"]Last would select the last record isn't? But here last record wont have all the field values. I guess I am missing some where. Forgot to mention, the two links of the Transformer should been be Funn ...[/quote] Hi Guys, Thanks you for the suggestions. I have 1 more questio...

[quote="ray.wurlod"]Build the output rows in a Transformer stage and use an output constraint of emp_id = 1043 or emp_id = 1059. (I've assumed your input is sorted as shown - if not, sort it.) Some of these rows will ...[/quote] Yes, the input data is sorted in asending order based on keyI...

Hi All, I have a incoming file in this format; Duplicate keyID's are allowed and each keyID has unique emp_id. keyID emp_id col3 101 1043 A 101 1059 B 101 1068 D 101 1069 E 102 1042 R 102 1041 T 103 1043 Y 103 1000 U 104 1059 O 104 1071 L 104 1072 K 104 1073 J My expected output should remove the du...

Hi All, I have a unique requirement. I have data coming in as 000232,00116 I have to capture the number of leading zeros and along with the 1st occurance of the number after the leading zeros. Eg: i have data coming in as 000232. in my output i should be able to see 42 (4 is the starting occurance a...

Hi,

I have a reference file, source file, copy then 6 outputs from copy and then 6 join stages. each join stage performing join on a key column from source file with refrence file.

can you suggest me where do i add the column generator..you mean after Join stage..

Regards
PA

Hi All, I have 6 separate Join stages in my job and I am performing a left outer Join on a key column in each of the 6 joins. The key column is different in each of the 6 joins. There is a output link coming from each Join. There are no Rejects. Here are the output link names; link_1 link_2 link_3 l...

Thanks Ray

Regards
Pa

Hi All, I have 2 sources. Source1 and soure2. I have a column in source1 as City and i have similar column in source 2 i.e City. There is another column called "ZIP" in my source1 and also source2. All of them are varchar. If city from source1 matches with city from source2 then I have to ...